Hello,
I would like to convert 000000028309094X to 4 digits with hyphen:
0000-0002-8309-094X. <--X is an alphabetic.
I was trying to do that with Regex tool. But it didn't work.
Does anyone know how to solve this issue?
Thank you,
Kazumi
Solved! Go to Solution.
Try this with the formula tool:
Substring([Field1],0,4) + '-' + Substring([Field1],4,4) + '-' + Substring([Field1],8,4) + '-' + Substring([Field1],12,4)
I like to break long formulas into multiple lines for clarity