Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

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

Dom
8 - Asteroid

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

 

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

3 REPLIES 3
jack_morgan
9 - Comet

Hey Dom!

This is actaully a built in function:

StripQuotes([Field1])

 

Best of Luck!

jack_morgan
9 - Comet

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
5 - Atom

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

Labels
Top Solution Authors