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
