Client needs a special format with double quotes "" around each field in .csv

[LBCoEnterprises]

Client needs a .csv file, but they open it and use it in a text editor like word pad. They need double quotes around each field.

Simple enough workflow as an example.

Here's what I have as sample data to start with

Here's what I need in the end when the .csv is opened in word pad

I have tried this:

But get this:

And I have tried this:

But it leads to triple double quotes around each field:

Any ideas?

[DanielG · Accepted solution]

 

@LBCoEnterprises   There is a setting on the output to "Always" add quotes.  Give this a shot.  It does quote the column headers too, so I am not sure if that is a deal breaker for you.

[LBCoEnterprises]

This is exactly what fixed it. I never noticed the feature on the output before.

Mine was set to 'Auto' which makes since because each time the formula didn't seem to work as it should have.

I changed mine to 'Never' and now I have exactly what I need.

Thanks again

[DanielG]

@LBCoEnterprises - no problem.  I had a similar situation in my past having to create CSVs for a vendor to load data to their tool for us.  I hadn't know it existed until that point either.  🙂