I need to clean and format Australian mobile numbers in in E164 format, I tried to use Regex but couldn’t get it to work, finding it really frustrating, can you please help with this specific problem I would be grateful.
Hey @Morgan_Drew
Happy to help! We’re often able to avoid using Regex by using other steps such as Find and Replace
and Extract Text from Columns
. Can you please provide some examples of the original starting format and your desired end format?