Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

substitute formula in excel

rohini
8 - Asteroid

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

4 REPLIES 4
JosephSerpis
17 - Castor
17 - Castor

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

 

 

Replace.PNG

RolandSchubert
16 - Nebula
16 - Nebula

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
8 - Asteroid

thank you

 

ThizViz
11 - Bolide

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

@thizviz aka cbridges, Bolide
http://community.alteryx.com/t5/user/viewprofilepage/user-id/2328
Labels