Regular Expression to Prefix Search Results with "000"

I want to prefix some data using a reqular expression.  I am using this expression to locate all UPC numbers that are 11 digitis in length.  ^\d{11}$   but I want to know if I can prefix the results with "000".  

Locate this:                              Transform to this:

20349098761                           00020349098761
hojohappyAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Terry WoodsIT GuruCommented:
What language or tool are you using?

If it was php you'd use something like:
$data = preg_replace('/^(\d{11})$/','000$1',$data);
0
Terry WoodsIT GuruCommented:
Using a lookahead is more elegant and should also work:
$data = preg_replace('/^(?=\d{11}$)/','000',$data);
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Derek JensenCommented:
preg_replace_all can prefix all of them at once:

$data = preg_replace_all('/^(?=\d{11}$)/','000',$data);  

Open in new window

0
käµfm³d 👽Commented:
@bigdogdman

Which documentation are you looking at? preg_replace_all doesn't appear to be a valid PHP function, and the preg_replace that Terry mentions will replace every occurrence by default--unless you specify how many occurrences to replace by passing an additional parameter.
0
Derek JensenCommented:
@Kaufmed,

You're absolutely right, I'm a tardbucket...I was thinking of preg_match_all. My bad. :">
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Regular Expressions

From novice to tech pro — start learning today.