Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
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

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?

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

bdgeddam9
New Contributor

Re: Searching Pattern in Data

using text function this will give aswer :

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