HELP!
I am trying to format account numbers in alteryx.
My account numbers are currently displayed as such:
1234567890
I am trying to display them as:
1234-567-890
What tool/formula do I use to get this result?
I know the answer is right in front of me but I am so lost!
Thanks in advanced!
Solved! Go to Solution.
The Regex tool with the following settings should work:(Note: Make sure your account number is a string with large enough size)
Best,
MSalvage