Only Characters after last . in String

[rustyfishbones]

Hi All,

I have file paths and I am using the following to get everything after a '.' or CHAR(46)

SUBFIELD([Full Path],'.',2)

However some file paths contain a number of  '.' but i only want everything after the last one

So if I have

Alan.qvw

Alan.Farrell.qvw

Alan.r

Alan.Farrell.r

I only want to see

.qvw

.r

Regards

Alan

[tresesco · Accepted solution]

Try:

SUBFIELD([Full Path],'.', -1)

[rustyfishbones]

thanks tresesco