Hi All,
I am trying to come up with a way of streamlining the data management of one of my apps. I have the database entries, over a thousand, in FileMaker Pro, and export this to a CSV file, which I import into the SQLite database used by my app. So far, so good.
What I don't seem to be able to solve is how to get the text to retain the returns I have in the original data. Once imported into the SQLite db, they all seem to be lost. I have experimented with double quotes, but with no luck. Maybe I'm just not understanding how the double-quotes should be used, but it's supposed to be supported.
If anyone has any experience in such things, I would appreciate your input.
I am trying to come up with a way of streamlining the data management of one of my apps. I have the database entries, over a thousand, in FileMaker Pro, and export this to a CSV file, which I import into the SQLite database used by my app. So far, so good.
What I don't seem to be able to solve is how to get the text to retain the returns I have in the original data. Once imported into the SQLite db, they all seem to be lost. I have experimented with double quotes, but with no luck. Maybe I'm just not understanding how the double-quotes should be used, but it's supposed to be supported.
If anyone has any experience in such things, I would appreciate your input.