Alteryx Designer Desktop Discussions

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

Replace specific character in a string dynamically

Nandakishore
8 - Asteroid

Hi,

 

I this requirement to replace specific character within a string where find and replace tool is not working .

 

Example : 

 

Find  Replace
Á      A
À      A
      A

Æ   AE

 

Also i do not want to hardcode the values because the list changes in future so cannot use formula tool . Is there anyway to do this . 

 

 

Thanks

4 REPLIES 4
ChrisTX
16 - Nebula

Can you post a sample workflow where the Find Replace tool is not working?

 

Screenshot 2024-01-22 053811.png

 

The tool is working OK in the attached workflow.

 

Chris

Nandakishore
8 - Asteroid

hi @ChrisTX,

 

My mistake. Actually the example is like this  : 

 

Incoming string       Expectedoutput 

AlexÆ                     AlexAE

 

Tool need to find Æ and replace with AE

 

Thanks

ChrisTX
16 - Nebula

Can you try the workflow I posted

Nandakishore
8 - Asteroid

hi @ChrisTX , 

 

Not working . Attached is workflow with sample data .

 

Thanks

Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Labels