Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Load SubField(Txt,'/',-1) Inline [
Txt
asr/098/yes/bcd/in
nfd/234/upl/nmd/a90/pak ];
Load SubField(Txt,'/',-1) Inline [
Txt
asr/098/yes/bcd/in
nfd/234/upl/nmd/a90/pak ];
substring(yourfieldname, '/',-1) as newfield
=SubField(YourFieldName,'/',-1)
Hi Anbu,
It's working, Thank you