Converting 16 digits to 4 digits with hyphen

Question

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

adm510 · Accepted Answer

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