Forum Discussion
Jeroen_Sunter
Mar 06, 2022Copper Contributor
How to create a csv-file with delimiter |”
I want to create an CSV-file with Excel. I want the delimiter to be |”
I tried to change Application.DecimalSeparator. But it looks like only one character is possible.
When I change the data in the sheet from multiple cells to one (in column A) and put the the delimiter in the data and save as csv, Excel splits the data automatically and puts in a not desired delimiter.
When I put in the | in the data cells and try to use “ (double quotes) as a delimiter, Excel still uses the comma as delimiter when saved as csv.
Any suggestions?
I tried to change Application.DecimalSeparator. But it looks like only one character is possible.
When I change the data in the sheet from multiple cells to one (in column A) and put the the delimiter in the data and save as csv, Excel splits the data automatically and puts in a not desired delimiter.
When I put in the | in the data cells and try to use “ (double quotes) as a delimiter, Excel still uses the comma as delimiter when saved as csv.
Any suggestions?
No RepliesBe the first to reply