Dynamic Rename Not Working to Remove Apostrophe
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
katherinetdavita
8 - Asteroid
‎04-22-2022
09:09 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Based on instructions from this post, I am trying to replace apostrophes in my data with spaces, but it's not working and I'm not sure what I'm missing. Sample data and workflow attached.
Labels:
- Labels:
- Preparation
3 REPLIES 3
20 - Arcturus
‎04-22-2022
09:22 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hint: "'"
Alteryx ACE & Top Community Contributor
Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
‎04-22-2022
09:27 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello again. Sorry, not catching on to the hint!
20 - Arcturus
‎04-22-2022
09:35 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
replace([_CurrentField_],"'","")
Should work. But if apostrophe is a smart apostrophe, you should copy it and paste the symbol
replace([_CurrentField_],"`","")
Alteryx ACE & Top Community Contributor
Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
