Free Trial

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
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
16 - Nebula

Can you try the workflow I posted

Nandakishore
8 - Asteroid

hi @ChrisTX , 

 

Not working . Attached is workflow with sample data .

 

Thanks

Labels
Top Solution Authors