Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
ALTER.NEXT:

Join us on Dec 2 for a half-day virtual analytics + data science event!
US & CA customers only

SAVE YOUR SPOT
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
SOLVED

Removing quotations - StripQuotes not working

7 - Meteor

Hi, 

I want to remove the double quotations from the second record in this data set. Neither StripQuotes nor Trim is working. What am I missing here? What's the solution? 

Thanks, 

Dan Stone

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Try using,

 

 

trim([Comment],'“')

 

 

You weren't doing anything wrong per se. This ascii character isn't considered a quotation mark. So all I did was copy and paste this “ is into your formula.

 

Hope this helps. 

 

Edit: It's actually a Left Double Quotation Mark which apparently isn't recognised by StripQuotes.

Highlighted
Alteryx
Alteryx

@Present_guy You can use the replace function in the formula tool to replace the quotes.

 

ReplaceFirst([Field2], '”', '')

ReplaceFirst([Field2], '“', '')
Digan
Alteryx
Highlighted
Alteryx Certified Partner

@Present_guy 

 

REGEX_REPLACE([Comment], '^[[:unicode:]]?(.+?)[[:unicode:]]?$', '$1')

Will also work. This will trim out any non-ascii character (or any char code over 255) that's found either at the beginning or end of the string... may be overkill, but just another option to explore.

Jimmy
Teknion Data Solutions 

Highlighted
7 - Meteor

@Present_guy 

 

You can also use a regular expression to strip the quotes out if you see this being a regularly occurring theme in your data. Hope this helps!

 

clipboard_image_1.png

Labels