Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

bdgeddam9
New Contributor

Searching Pattern in Data

Hi i have data as follows and basically need data before "@" and after "/"

us/us 2013/us@2018/uk

1 Solution

Accepted Solutions

Re: Searching Pattern in Data

This gives us

=SubField(SubField('us/us 2013/us@2018/uk', '@', 1), '/', -1)


Capture.PNG

View solution in original post

6 Replies

Re: Searching Pattern in Data

Since '/' repeats multiple times, which one do you want to consider? In essence what is the string that you would like to pull out?

Highlighted

Re: Searching Pattern in Data

One option can be to try this

=TextBetween('us/us 2013/us@2018/uk', '/', '@')

Re: Searching Pattern in Data

Or this

=SubField(SubField('us/us 2013/us@2018/uk', '@', 1), '/', -1)

bdgeddam9
New Contributor

Re: Searching Pattern in Data

Hi Thanks Sunny.

I am looking for "us" .I think either of functions gives answer

Re: Searching Pattern in Data

This gives us

=SubField(SubField('us/us 2013/us@2018/uk', '@', 1), '/', -1)


Capture.PNG

View solution in original post

bdgeddam9
New Contributor

Re: Searching Pattern in Data

using text function this will give aswer :

=TextBetween('us/us 2013/us@2018/uk', '/', '@',2)