Removing quotations - StripQuotes not working
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
- Labels:
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Present_guy You can use the replace function in the formula tool to replace the quotes.
ReplaceFirst([Field2], '”', '')
ReplaceFirst([Field2], '“', '')
Alteryx
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
