Php format numbers in a string with regexp

Question

I need help with writing a regular expression in PHP. I am not friend enough to get it right. I need to find all integers in a string and format them as follows:

1 to 001000
0.13 to 000130
100 to 0100000

and so on. In normal speech it means - edit the number prepend it with zeros or edit it to be in same "order". The point is to have all of the integers it the string in this format (6 numbers). Could someone help me please? I will not post my tryouts here because they are too foolish:-)

Could there be negative numbers? If so, what should happen with them? Could there be decimal numbers without a leading zero like .13? — Tim Pietzcker
– Tim Pietzcker, Commented Oct 11, 2010 at 8:18
No to all. There can be only positive values with leading zeros. I get the input from XML file which contains only values as 13 or 20 or 186.578962453. I need to strip the values and make it exactly 6 digits. It will be yoused for searching purposes. — Bery
– Bery, Commented Oct 11, 2010 at 8:26

codaddict · Accepted Answer · 2010-10-11 08:09:38Z

2

From your examples looks like you are multiplying the number with 1000 and prefixing them with 0's to make a total of 6 digits. If that is true you can just do:

sprintf("%06d",$n*1000);

answered Oct 11, 2010 at 8:09

codaddict

457k83 gold badges501 silver badges537 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Bery Over a year ago

It is not exactly multiplying. I need to have all numbers to have exactly the same lenght. The range is "000.000" to "999.999". And for every number in the input string i need an output which looks like "xxxxxx". Exactly six digits (with prepending zeros) without a point.

Community · Accepted Answer · 2017-05-23 12:11:47Z

1

By using the 'e' modifier on preg_replace() (or using preg_replace_callback()) you can use @codaddict's answer:

function my_format($d) {
    return sprintf('%06d', round($d * 1000));
}

$your_string = '0.12 100 number 1.12 something';

preg_replace('/\d+(\.\d+)?/e', 'my_format(\\0)', $your_string);
// Should give '000120 100000 number 001120 something'

edited May 23, 2017 at 12:11

CommunityBot

11 silver badge

answered Oct 11, 2010 at 8:15

jensgram

31.6k6 gold badges83 silver badges101 bronze badges

4 Comments

jensgram Over a year ago

@codaddict Right. I should have copy-pasted your code instead :)

Bery Over a year ago

Thanks guys for quick responses. I'll give it a try and let you know:-)

Bery Over a year ago

I tryied proposed solution - there should be round($d.... Unless I am guessing something wrong - i need to change ALL of the numeric values including 1.12 in @jengram's example. And also when I tested it - it strips the space after the number. What I need is to let the rest of the string intact. The purpose of this code is to process Zend Lucene query in order to be capable searching float point numbers.... :-) I know I am being...iritating :-D

jensgram Over a year ago

@Bery Yes, the round() was a(nother) typo. About the 1.12 I misread your comment. I have (hopefully) fixed it now.

Collectives™ on Stack Overflow

Php format numbers in a string with regexp

2 Answers 2

1 Comment

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related