Discussion Board for collaboration related to QlikView App Development.
Hi i have data as follows and basically need data before "@" and after "/"
Go to Solution.
This gives us
=SubField(SubField('us/us 2013/us@2018/uk', '@', 1), '/', -1)
View solution in original post
Since '/' repeats multiple times, which one do you want to consider? In essence what is the string that you would like to pull out?
One option can be to try this
=TextBetween('us/us 2013/us@2018/uk', '/', '@')
Hi Thanks Sunny.
I am looking for "us" .I think either of functions gives answer
using text function this will give aswer :
=TextBetween('us/us 2013/us@2018/uk', '/', '@',2)