Parsing Continuous String Value

[jrkmorgan]

I need to parse a ten digit string value to reformat. My end result should look like this:

Column A           Column B

1234567890        12-345-67890

0123456789        01-234-56789

All of column A will be 9 or 10 digits with the 9 digit values needing a preceding 0 if one is not present. Column B will always be 12 including the dashes.

In Excel the formula leveraged is Left($a1,2)&"-"&mid($a1,3,3)&"-"&mid($a1,6,5)

What's the most efficient way to do this in AD?

[jrlindem · Accepted solution]

You can do this the same way you are doing it in excel with a couple slight changes:

Here's the formula string:  Left([Data],2) + "-" + Substring([Data],2,3) + "-" + Substring([Data],5,5)

[jrkmorgan]

Substring! Thank you! I need more coffee today.

[jrlindem]

Don't we all!  Glad I could help, have a good weekend, and happy Alteryx'ing!  -Jay