topic Re: String Question in QlikView

String Question

tmumaw — Tue, 15 Mar 2016 14:27:37 GMT

Hello all,

I have a question for you. I have a string that I only want to extract up to the first ' - '. How would I do this?

Example:

AR Analysis -

Sales Analysis -

CRM Stats -

Thanks

Thom

sunny_talwar — Tue, 15 Mar 2016 14:29:19 GMT

May be this:

SubField(MyString, ' -', 1) as MyNewString

MK_QSL — Tue, 15 Mar 2016 14:32:51 GMT

Trim(SubField(MyString,'-',1)) as MyNewString

tmumaw — Tue, 15 Mar 2016 15:16:24 GMT

Sunny T,

Here is what I got and all I need out of the string is ar analysis. I need to strip off the d:\accesspoints\ and - 135131 _ youngstown-fs.qvw

Thanks

Thom

d:\accesspoint\ar analysis - 133531 _ youngstown-fs.qvw

tmumaw — Tue, 15 Mar 2016 15:17:13 GMT

One thing to remember it might be ar analysis or crm stats or billing analysis

MK_QSL — Tue, 15 Mar 2016 15:29:53 GMT

SubField(TextBetween('d:\accesspoint\ar analysis - 133531 _ youngstown-fs.qvw','\',' -'),'\',-1) as YourOutput

SubField(TextBetween(YourFieldName,'\',' -'),'\',-1) as YourOutPut

tmumaw — Tue, 15 Mar 2016 17:31:23 GMT

Thanks Manish.....It worked perfect.

tmumaw — Tue, 15 Mar 2016 17:31:43 GMT

Thanks everyone for your help.