Subject Re: insert dash after N characters in a strings From kent <gkent_28@yahoo.com> Date Mon, 25 May 2015 22:30:42 -0400 Newsgroups dbase.getting-started Ivar B. Jessen Wrote: > On Mon, 25 May 2015 03:15:48 -0400 kent >  Sender:  kent <gkent_28@yahoo.com> >  wrote the following in: >  Newsgroup: dbase.getting-started >  Subject: insert dash after N characters in a strings: >  MessageID:<G7BsfqrlQHA.192@ip-AC1E04A7> >   > >I have this project where i want put dashes in every characters; > > > >I want that whenever i type on a certain entryfield the system will automatically put dashes in it. > > > >like 999WYZ999 TO 999-XYZ-999-000 - also 3 zeros will be automatically added ... > > > >or 999WWXX44E  = 9-99W-WXX-44E > > > > In the first example you insert a dash for every three characters in the string > and add a dash followed by three zeros. > > In the second example you add a dash after the first character of the string and > then a dash for every three characters, but you do not add a dash followed by > three zeros.   > > In order to get any help you need to explain clearly the rule(s) you follow for > inserting dashes and zeros in the first and second examples. > > > Ivar B. Jessen Hi, On the first example 999-999-999-000: this is on a separate entry field , on this field I want it in such a way that every 3 character there's a 'DASH' , and on the end 3 zeros will be automatically added. on the 2nd example  9-99W-WXX-44E: this is also on the separate field. the difference is that the dashes are located differently and no additional zeros are added after the values. sorry guys for not clearing this out. Thanks in advance.