String Question

[tmumaw]

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]

May be this:

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

[MK_QSL]

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

[tmumaw]

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]

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

[MK_QSL · Accepted solution]

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

or

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

[tmumaw]

Thanks Manish.....It worked perfect.

[tmumaw]

Thanks everyone for your help.