Need help with delimiters ...perhaps

[Brad1]

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?

[FrederikE · Accepted solution]

Hey @Brad1,

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

[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.