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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.