Change format of Cell/Mobile number
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 ?
Solved! Go to Solution.
- Labels:
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Just trying a different version of the formula
Replace(replace(Replace([Phone],'+61',''),'(4)','04'),' ','')
Regards
Arundhuti
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Now how to convert a string into a phone number
8,005,313,276