Alteryx Designer Desktop Discussions

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

Formula, Parse, RegEx?

IJH34
8 - Asteroid

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!

1 REPLY 1
MSalvage
11 - Bolide

@IJH34,

 

The Regex tool with the following settings should work:(Note: Make sure your account number is a string with large enough size)

IJH34 Regex Solution.PNG

 

 

Best,

MSalvage

Labels