Subject Re: manipulating a string From Lee Grant <camilee@nospam.comcast.net> Date Sun, 20 Mar 2022 17:29:51 -0400 Newsgroups dbase.getting-started Mervyn, Thanks for showing me one way to use my new regex skills in dBASE with this example.  I've heard you mention you like using it here, but wasn't sure how you did that. Now I know. :) Robbie, Thanks for also showing another way to skin that cat. :) Lee On 3/20/2022 12:51 PM, Mervyn Bick wrote: <snip> > It can be done using dBASE functions but using a regular expression will > do the job a lot faster. > > A little example is attached.  It will add 0 to the front of 4 digits > between any number of character at the beginning of the sku and any > number of characters at the end of the sku.  If there are 5 digits no > change will be made. > > There shouldn't be a problem but make sure you have a backup of the > table safely tucked away before you run the program. > > Mervyn