Change format of Cell/Mobile number

Question

Hi all

I have an Alteryx Designer WorkFlow and one of the fields i use in a Cell/Mobile number which is currently in the format of +61 (4) 1212 3123. I need to modify it to the format of 0412123123. Formatting of the cell/mobile numbers will never change.

I have been trying to work out how to change the format for the last few days (time permitting) but haven't been able to work it out.

Would anyone have a suggestions as to changing this format ?

Luke_C · Accepted Answer

I'm sure there's a number of approaches for this with parsing/regex, but the below formula would work for your example. Are there ever instances where there would be two digits in the parentheses?

"0" +substring(replacechar([Field1],"() ",""),3,9)

Tyro_abc · Accepted Answer

Just trying a different version of the formula

Replace(replace(Replace([Phone],'+61',''),'(4)','04'),' ','')

Regards

Arundhuti

StephenT · Accepted Answer

Thanks @Tyro_abc and @Luke_C

Those 2 solutions work equally well, so I will mark them both as accepted as solution.