Parsing the last occurrence of a string pattern

[Anonymous]

Some sample strings:

1) www.abc.com

2) xyz.com

3) www.123.com/page.pdf

4) www.123.com/section/secondpage.html

I would like to be able to find the last period in the string and take all of the data after that period.  So the results would be:

1) com

2) com

3) pdf

4) html

[Anonymous · Accepted solution]

use subfield function:

subfield (<Your string field>, '.', -1)

[swuehl]

Try something like

subfield(SAMPLESTRING, '.', -1)

[Anonymous]

Thanks, I did not realize that there was a -1 option!  Works great.