Insert dash when text-code changes from numbers to letters

[macfan55]

How do I split a text-code like 2VBG45 or CF34HJ into 2-VBG-45 and CF-34-HJ

What I want to achieve is insert a dash at the place where the text changes from letters to numbers and were it changes from numbers to letters.

The by our customer delivered text-code is always 6 digits but the place/amount of numbers and letters are not always the same. So the total of numbers and letters is always 6 but the amount of letters and numbers in each code can be 2-4 3-3 and 4-2 so there ale always 2 dashes to insert.

Any help will much be appreciated.

[David Miller]

How do I split a text-code like 2VBG45 or CF34HJ into 2-VBG-45 and CF-34-HJ

What I want to achieve is insert a dash at the place where the text changes from letters to numbers and were it changes from numbers to letters.

The by our customer delivered text-code is always 6 digits but the place/amount of numbers and letters are not always the same. So the total of numbers and letters is always 6 but the amount of letters and numbers in each code can be 2-4 3-3 and 4-2 so there ale always 2 dashes to insert.

Any help will much be appreciated.

 

You can try this:

var str = Field("Number"); // Replace with your field name.

var regexStr = str.match(/[a-z]+|[^a-z]+/gi);

return regexStr.join("-");

[macfan55]

Thanks! that works great!