Hi All,
I have a data where the reference number is something like bg/ nngk/nm d /1355, I want to remove the blank and the "/" from the reference number. I use =SUBSTITUTE(SUBSTITUTE(L2,"/","")," ","") formula how can this be done in alteryx.
thank you
Regards
rohini
Solved! Go to Solution.
Replace(Replace(Column, "/", "")," ","") just ensure Column is replaced with the field/column with the reference number in a formula tool.
Hi @rohini ,
it's very similar to Excel ... use "REPLACE" instead of "SUBSTITUTE" and remove the "=" and you are done.
Formula is: Replace(Replace([Field1], "/", ""), " ", "")
Best,
Roland
thank you
Kindly click "Accept as Solution" for both these answers.