Hello everyone:
I am developing a small app using Sqlite as the database. it is only text.
When i am searching some records, i receive '\r\n', carriage return and new line in my screen.
How can i replace them for spaces???
Thank you in advance.
Negrazo49
When does this happen?
Is the carriage return in your base data or only in your data return to your app.
Show an example.
Whether going into or out of SQLite, the AI2 text replace block can take \r and \n as replaceable characters.
which extension are you using for your project?
I do not think this would happen using my extension from here App Inventor Extensions: SQlite | Pura Vida Apps
It would really help if you provided a screenshot of your relevant blocks, so we can see what you are trying to do, and where the problem may be.
To get an image of your blocks, right click in the Blocks Editor and select "Download Blocks as Image". You might want to use an image editor to crop etc. if required. Then post it here in the community.
Taifun
Dear Taifun.
Thank you for your answer but this issue was solved.
I was doing things well, but the problem was in the source, the Sqlite database, i made the replacements there twice and then i uploaded the DB into my app, but finally i noticed that the DB has the "read only" in the permissions, so simply changed it and everything works just fine. Thank you again.
Sincerely,
Negeazo49.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.