How to use SUBSTITUTE in Alteryx

[Peter15653111]

Hi,

how to use substitute in Alteryx? 

below formula I used in excel, how can I use Alteryx to achieve instance_num function.

SUBSTITUTE(Text, old_text, new_ text, instance_num)

For example, I want to replace the second "A" with "B" in ID NUMBER, the correct ID NUMBER should display as below.

ID NUMBER           Correct ID NUMBER
AA213DFSF    ---         AB213DFSF

AAAASSDD     ---         ABAASSDD

213ABBBA      ---          213ABBBB 

[ShankerV]

Hi @Peter15653111 

Please use the below 2 tools.

1. Text to Columns tool

2. Then Formula tool to join back.

Many thanks

Shanker V

[ShankerV · Accepted solution]

Hi @Peter15653111 

Please find the use case explained.

 

Step 1: Input

 

Step 2:

 

Step 3:

 

 

Step 4:

 

Many thanks

Shanker V

[Peter15653111]

Thank you Shanker