PHP substr - extract numbers from string

Question

I need to extract the highlighted numbers from each line in a CSV file.

Currently I am looping though the lines & splitting the line on the / character as this only appears once in each row, but how do I remove everything around these numbers so I am left with:

9/10

10/11

11/12

...

Why don't you try fgetcsv() with ~ as the delimiter?

Sammitch
– Sammitch

2019-02-06 19:37:46 +00:00
Commented Feb 6, 2019 at 19:37 — Sammitch
– Sammitch, Commented Feb 6, 2019 at 19:37

ren.rocks · Accepted Answer · 2019-02-06 18:30:41Z

4

If you want to only get the numbers, you could do a preg_match

$re = '/(\d+\/\d+)/s';
$str = 'dfsadsfadsfads~~9/10~~lfkjdskfds';

preg_match($re, $str, $matches);

but if you are able to get the entire doc as a single string, you could do a preg_match_all

$re = '/(\d+\/\d+)/s';
$str = 'dfsadsfadsfads~~9/10~~lfkjdskfds\ndfsadsfadsfads~~9/10~~lfkjdskfds\n';

preg_match_all($re, $str, $matches, PREG_SET_ORDER, 0);

then loop on the $matches

edited Feb 6, 2019 at 18:30

answered Feb 6, 2019 at 18:07

ren.rocks

7921 gold badge7 silver badges22 bronze badges

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

6 Comments

kb. Over a year ago

Thanks, but seems to be stripping the left number to a single digit 9/10 0/11 1/12 3/14 - Also these numbers can be much larger than double digits

ArtisticPhoenix Over a year ago

I would just add that you don't really need the m flag here. It's only relevant to the start and end of a string such as the use of ^ or $. Basically it changes those so they match the start and end of a line, instead of the whole string (the default behavior). It doesn't hurt anything to have it, just thought I would mention it. Otherwise, it's what I would have done.

ren.rocks Over a year ago

@kb I fixed the left number issue by adding a + symbol to the regex. Should work like needed.

ren.rocks Over a year ago

@ArtisticPhoenix I removed the m flag as suggested

ArtisticPhoenix Over a year ago

@rtrigoso - Kool, I already upvoted you so I would do it again but alas I cant :)

|

Collectives™ on Stack Overflow

PHP substr - extract numbers from string

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related