How to Search in String

[Anonymous]

Hi,

I have a string which has different values in it, it was delimited with '/'. How to get last keyword in string. sometimes it was after 5th '/' and some time its after 4th '/' from starting. Is there anyway to get sub field from the end?

eg:

1)asr/098/yes/bcd/in

2)nfd/234/upl/nmd/a90/pak

OutPut:

1)in

2)pak

[anbu1984 · Accepted solution]

Load SubField(Txt,'/',-1) Inline [

Txt

asr/098/yes/bcd/in

nfd/234/upl/nmd/a90/pak ];

[#3]

substring(yourfieldname, '/',-1) as newfield

[MK_QSL]

=SubField(YourFieldName,'/',-1)

[Anonymous]

Hi Anbu,

It's working, Thank you