I converted a database from Psion format to csv format but in the process it converted all “£” entries to “œ”. I therefore used “Replace All” to convert œ to £. Problem is, when I save the changes and then reopen the file all my “£” have changed to “$” and this then pulls through into my Tap Form. Any idea why using csv format is changing £ to $ every time? Thanks.
The only way I can cure the problem is by inserting “GBP” instead of “£”. My bigger problem is loss/corruption of data when importing: see separate post.
Hello Fmrtao,
This is most likely a file encoding issue. The issue you had with loss/corruption of data is also possibly due to encoding and/or missing quotes around comma delimited data.
For example, if you had a comma delimited file and you wanted to import it, if any of your column values themselves had commas in them, you would have to make sure you have double-quotes around the column value. Also note that for every data row, you MUST have the same number of delimiters (commas in this example) as you do in your header row. So if I had 3 columns in my header row, there must be 2 delimiters and 2 delimiters in all your data rows. In other words, the number of delimiters is the number of columns minus 1.
Thanks,
Brendan
Not sure I can follow this. But the answer seems to be in the other string that I started. When I used the format you suggested the “£” stayed.
.
