Greeting Dear community,
We have a xlsx file that we need to generate a pipe de-limited csv file.
We use the default option and the delimitor is ,
and the text field is quoted with "
However, that text field sometimes has " itself. If so it confuses our down-stream data-loading and it creates error.
We have a python script that does the data-scrubbing but our boss says that the DevOp folks might not have the python module installed to do the data scrubbing and ask us if excel can generate a delimited file other than the default option.