MarcomCentral (PTI) and FusionPro User Communities

MarcomCentral (PTI) and FusionPro User Communities (http://forums.pti.com/index.php)
-   Formatting Text (http://forums.pti.com/forumdisplay.php?f=32)
-   -   Insert dash when text-code changes from numbers to letters (http://forums.pti.com/showthread.php?t=5279)

macfan55 January 24th, 2019 05:45 AM

Insert dash when text-code changes from numbers to letters
 
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 January 24th, 2019 01:18 PM

Re: Insert dash when text-code changes from numbers to letters
 
Quote:

Originally Posted by macfan55 (Post 21680)
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:
Code:

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

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

return regexStr.join("-");


macfan55 January 25th, 2019 06:47 AM

Re: Insert dash when text-code changes from numbers to letters
 
Thanks! that works great! :)


All times are GMT -7. The time now is 11:16 PM.

Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) 2011, PTI Marketing Technologies™, Inc.