PHP Remove Value of String with Variable Numbers

Question

Basically from a database I am getting data that is formatted like this nameofproject101 Now this could continue to increase so eventually it could be nameofproject1001 my question is how can I trim off the number and just get the name of the project. I thought about using substr but since I dont know the length always I cant really do that. Since the numbers differ I dont think I can use str_replace is there any way to accomplish this?

Use regular expression to strip out trailing numbers. stackoverflow.com/questions/2123334/… — thenetimp
– thenetimp, Commented Feb 5, 2012 at 18:02
@erisco From the database yes it is stored like 'nameofproject101' I need it to be 'nameofproject', but what I need to do with the data, I dont need the numbers so I need them stripped off. — atrljoe
– atrljoe, Commented Feb 5, 2012 at 18:04
@atrljoe I believe erisco was asking whether the name (without the trailing numbers) could contain numbers. E.g. r2d2translator1001. — kba
– kba, Commented Feb 5, 2012 at 18:11

kba · Accepted Answer · 2012-02-05 18:07:06Z

3

It sounds like something is way off about your database scheme. You should probably try to do refactor/normalize your scheme.

But in the meantime, you can use rtrim() to trim all numbers off of the right side.

$val = rtrim($val, '0123456789');

Examples

Input               Output
nameofproject1001   nameofproject
nameofproject       nameofproject
n4me0fproj3ct1001   n4me0fproj3ct

answered Feb 5, 2012 at 18:07

kba

19.5k6 gold badges65 silver badges90 bronze badges

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

Comments

ThinkingMonkey · Accepted Answer · 2012-02-05 18:11:56Z

1

for string like, project12V123, It is better to do this

$text = `project12V123`;
$text = preg_replace('/([\w]+)([^0-9])([0-9])+$/', '$1$2', $text);

Will return:

Project12V

or use rtrim:

$text = rtrim($text,'0123456789');

answered Feb 5, 2012 at 18:11

ThinkingMonkey

12.7k13 gold badges59 silver badges81 bronze badges

Comments

Tom Desp · Accepted Answer · 2012-02-05 18:16:02Z

0

You should definitely use regular expressions:

$fullname = "nameofproject101";
preg_match("/([a-z]+)([0-9]+)/i", $fullname, $matches);
$name   = $matches[1];
$number = $matches[2];
echo "'$fullname' is '$name' followed by '$number'";

answered Feb 5, 2012 at 18:16

Tom Desp

9217 silver badges19 bronze badges

1 Comment

kba Over a year ago

This will turn version2project101 into version. OP probably wants version2project.

newToJava · Accepted Answer · 2012-02-05 18:24:36Z

-1

preg_replace('/[^a-z]/i', '', $string);

edited Feb 5, 2012 at 18:24

answered Feb 5, 2012 at 18:10

newToJava

1732 silver badges15 bronze badges

2 Comments

Josh Over a year ago

@Kristian That's what I was hinting at. ;)

kba Over a year ago

The above will turn r2d2translator1001 into rdtranslator. Probably not what OP wants.

Collectives™ on Stack Overflow

PHP Remove Value of String with Variable Numbers

4 Answers 4

Comments

Comments

1 Comment

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related