Alteryx Designer Desktop Discussions

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

Dynamic Rename Not Working to Remove Apostrophe

katherinetdavita
8 - Asteroid

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.

3 REPLIES 3
MarqueeCrew
20 - Arcturus
20 - Arcturus

Hint:  "'"

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
katherinetdavita
8 - Asteroid

Hello again. Sorry, not catching on to the hint! 

MarqueeCrew
20 - Arcturus
20 - Arcturus

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.
Labels
Top Solution Authors