substitute formula in excel

Question

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 Answer

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

RolandSchubert · Accepted Answer

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