Subject: problems with csv files Posted: 6/1/2018 Viewed: 5911 times
Hi,I have problems with CSV files when I move them from my laptop to my desktop computer. All columns disappear and merge into one column with all previously entered data.
How can I solve this problem?
Mr. Jack Sieber
Subject: Re: problems with csv files Posted: 6/16/2018 Viewed: 5849 times
It might be an issue with different Windows List Separator characters on the two computers. Because the list separator varies from country to country, it is a good practice to always include the $ListSeparator directive in the CSV file so that WEAP can read the file, regardless of the setting of the Windows List Separator character. This is helpful if the dataset is shared between users in different countries. If you will be editing your CSV file in Excel, you should enclose this entire directive in quotes so that Excel doesn't interpret the list separator character as an actual list separator, e.g., "$ListSeparator = ,"