Need help with delimiters ...perhaps

Hi,

Thanks in advance for any help. I have the following input and want the following output in .csv

Have Need

Field1 Field2 Field3 "abc","123","B12"

abc 123 B12

I need to drop the Headers and everything needs to be in double quotes and needs to separated by a comma. What is the best/easiest way to go about that?

Reporting

Output

Parse

Accepted answers

FrederikE

Hey @Brad1,

You can use a Transpose and Summarize tool to get to such a concatinated string.

New Workflow2.yxmd

All comments

FrederikE

Hey @Brad1,

You can use a Transpose and Summarize tool to get to such a concatinated string.

New Workflow2.yxmd

Brad1

I came up with: [added field] + [Field 1] + [added field]

where the 'added field' is an input tool with " inside and appended in

then I can do the comma as the delimiter

It's not a great solution because of so many fields in the file

Brad1

Thanks. I like better than my answer.

Quick Links

This months top contributors

SophiaF 432

AkimasaKajitani 390

mceleavey 388

mbarone 337

michael_weaver 335