How to mask?

[YanivZi]

I have a field which contain 17 digits i will like to split it.

turn this:

00120190139007009

into this:

001201-9-0139-007-00-9

[vinieme12 · Accepted solution]

as below

=left(fieldname,6)&'-'&mid(fieldname,7,1)&'-'&mid(fieldname,8,4)&'-'&mid(fieldname,12,3)&'-'&mid(fieldname,15,2)&'-'&right(fieldname,1)