How do you remove Quotes at the beginging and end of line?

[Dom]

sample output data "97561525,3546,1001339556,,S,Tollar"

I would like it to look like this 97561525,3546,1001339556,,S,Tollar

[jack_morgan · Accepted solution]

Hey Dom!

This is actaully a built in function:

StripQuotes([Field1])

Best of Luck!

[jack_morgan · Accepted solution]

Hey Dom,

Per our chat on the phone, it was actually the output tool setting that was giving you the problem after you altered your workflow to transpose data, and then union on the trailer. Changing the delimiter to \0 allowed you to force the tool to NEVER display quotes on the data and also kept your trailer in tact.

It was great talking with you!

Jack

[Jan_man]

But in this case, when we have null for any columns the delimiter is getting misse dout. Please help if there is any other way to resolve this