substitute formula in excel

[rohini]

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

[JosephSerpis · Accepted solution]

Replace(Replace(Column, "/", "")," ","")  just ensure Column is replaced with the field/column with the reference number in a formula tool.

[RolandSchubert · Accepted solution]

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

[rohini]

thank you

[ThizViz]

Kindly click "Accept as Solution" for both these answers.