Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
pradeepm
Contributor II
Contributor II

How to Search in String

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

1 Solution

Accepted Solutions
anbu1984
Master III
Master III

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

Txt

asr/098/yes/bcd/in

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

View solution in original post

4 Replies
anbu1984
Master III
Master III

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

Txt

asr/098/yes/bcd/in

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

View solution in original post

Not applicable

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

MK_QSL
MVP
MVP

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

pradeepm
Contributor II
Contributor II
Author

Hi Anbu,

It's working, Thank you