Keeping comma in .csv file
Quote from saeid on February 17, 2022, 1:16 pmHi,
I have a .csv file which is called in my program. Some of the cells in this .csv file contain comma (,). For example one of the cells is a, b, c.
How can I keep these commas?
I searched it and the only solution which was proposed is wraping the cell in a double quote. Foe example: "a, b, c".
But this solution didn't work for me.
Could any one held me?
Hi,
I have a .csv file which is called in my program. Some of the cells in this .csv file contain comma (,). For example one of the cells is a, b, c.
How can I keep these commas?
I searched it and the only solution which was proposed is wraping the cell in a double quote. Foe example: "a, b, c".
But this solution didn't work for me.
Could any one held me?
Quote from luishp on February 17, 2022, 1:51 pm@saeid how do you create the .csv file?
Note that you can use a different separator character instead of a comma. Most common characters are ";" or "|" or tab.
Regards.
@saeid how do you create the .csv file?
Note that you can use a different separator character instead of a comma. Most common characters are ";" or "|" or tab.
Regards.
Quote from dglojnar on February 17, 2022, 4:32 pm@saeid
As Luis said, how do you create your CSV file?
From program, manually?
Recieve from external source?
If you made CSV file from Neobook/VisualNeo Win using one of the DB plug-ins, you can easily select separator - for CSV files common separator is ";", not comma...
If you recieve CSV file from external source, simply replace all commas to ";" , or you can write a small procedure from within a VisualNeo to perform this task.
And finally if you create CSV file with your own app, just change separator to ";".
Hope this help....
As Luis said, how do you create your CSV file?
From program, manually?
Recieve from external source?
If you made CSV file from Neobook/VisualNeo Win using one of the DB plug-ins, you can easily select separator - for CSV files common separator is ";", not comma...
If you recieve CSV file from external source, simply replace all commas to ";" , or you can write a small procedure from within a VisualNeo to perform this task.
And finally if you create CSV file with your own app, just change separator to ";".
Hope this help....
Quote from saeid on February 18, 2022, 1:07 am@luishp
@dglojnar
I created the .csv file by svaing an excel file as .csv format.
Could you please tell me how I can change the separator to ";" ?
I created the .csv file by svaing an excel file as .csv format.
Could you please tell me how I can change the separator to ";" ?