PHP regexp; extract last part of string

Question

A column in my spreadsheet contains data like this:

5020203010101/FIS/CASH FUND/SBG091241212

I need to extract the last part of string after forwward slash (/) i.e; SBG091241212

I tried the following regular expression but it does not seem to work:

\/.*$

Any Idea?

score 3 · Answer 1 · answered Mar 21 '14 at 10:52

3

Try this:

'/(?<=\/)[^\/]*$/'

The reason your current REGEXP is failing is because your .* directive matches slashes too, so it anchors to the first slash and gives you everything after it (FIS/CASH FUND/SBG091241212).

answered Mar 21 '14 at 10:52

Mitya

30,438
7
46
79

this also doesn't work `http://regexpal.com/?flags=g&regex=%28%3F%3C%3D\%2F%29[^\%2F]*%24&input=5020203010101%2FFIS%2FCASH%20FUND%2FSBG091241212` – php_nub_qq Mar 21 '14 at 10:53
2

@php_nub_qq: It's because you use a tester for javascript regexes (that doesn't support lookbehind assertions). Try with http://regex101.com and you will see that it works well. – Casimir et Hippolyte Mar 21 '14 at 11:01

Shankar Damodaran · Answer 2 · 2014-03-21T11:54:36.923

1

Make use of substr() with strrpos() as a look behind.

echo substr($str,strrpos($str,'/')+1); //"prints" SBG091241212

Demo

edited Mar 21 '14 at 11:54

answered Mar 21 '14 at 10:51

Shankar Damodaran

65,155
42
87
120

TBH regex gurus don't need to know abt it though ;) – Shankar Damodaran Mar 21 '14 at 11:26
Thanks, but if you want to see real gurus, you can take a look at this post: http://stackoverflow.com/questions/17039670/vertical-regex-matching-in-an-ascii-image – Casimir et Hippolyte Mar 21 '14 at 11:37
I just lost myself ! :) – Shankar Damodaran Mar 21 '14 at 11:53

score 1 · Answer 3 · answered Mar 21 '14 at 10:52

1

You could do it like this without reg ex:

<?php

echo end(explode('/', '5020203010101/FIS/CASH FUND/SBG091241212'));

?>

answered Mar 21 '14 at 10:52

Latheesan

19,790
25
89
173

score 1 · Accepted Answer · answered Mar 21 '14 at 10:53

1

You need to specify a matching group using brackets in order to extract content.

preg_match("/\/([^\/]+)$/", "5020203010101/FIS/CASH FUND/SBG091241212", $matches);

echo $matches[1];

answered Mar 21 '14 at 10:53

Jon

11,360
4
28
44

This is the best answer, other people used code other than regular expression to get correct results. – asim-ishaq Mar 21 '14 at 11:01
@asim-ishaq: Yes, however, keep in mind that the regex way can be slower than the use of build-in functions. – Casimir et Hippolyte Mar 21 '14 at 11:06
Perfectly good answer, though it's not essential to use sub-matches. A look-behind would also suffice. – Mitya Mar 21 '14 at 11:52

score 1 · Answer 5 · answered Mar 21 '14 at 11:05

1

this will do a positive lookbehind and match upto a value which does not contain a slash

like this

[^\/]*?(?<=[^\/])$

this will only highlight the match . i.e. the last part of the url

demo here : http://regex101.com/r/pF8pS2

answered Mar 21 '14 at 11:05

aelor

9,803
2
27
43

score 0 · Answer 6 · answered Mar 21 '14 at 10:54

0

You can 'explode' the string:

$temp = explode('/',$input);
if (!empty($temp)){
    $myString = $temp[count($temp)-1];
}

answered Mar 21 '14 at 10:54

Gwenc37

2,038
7
16
22

score 0 · Answer 7 · answered Mar 24 '14 at 02:50

0

You can also use:

$string = '5020203010101/FIS/CASH FUND/SBG091241212';
echo basename($string);

http://www.php.net/manual/en/function.basename.php

answered Mar 24 '14 at 02:50

mayrop

611
8
15

PHP regexp; extract last part of string

7 Answers7

Linked