topic Parse out text between two identifiers in QlikView

Parse out text between two identifiers

Fri, 11 Jul 2014 15:43:43 GMT

Hi,

I'm having a little bit of an issue parsing out text found in between two identifiers (strings)

What I am trying to accomplish is below - for example

I have a string field named resource and it has the following values:

|Wireless Transport|WT-ABC-1505|Process statistics

|Wireless Transport|WT-ABC-1506|Process statistics

What I want as the result is to extract the data found between |Wireless Transport| and |Process statistics|, however I do not want to include the numerical text as the result. What I would expect the result to be is as below:

WT-ABC

WT-XYZ

If anyone has any suggestions to parse out this information that would be great!

Thank you in advance.

Re: Parse out text between two identifiers

Gysbert_Wassenaar — Fri, 11 Jul 2014 15:47:30 GMT

Maybe left(TextBetween(MyField, '|Wireless Transport|','|Process statistics'),6)

Re: Parse out text between two identifiers

alexandros17 — Fri, 11 Jul 2014 15:49:56 GMT

try this:

Mid(Textbetween(resource,'|Wireless Transport|', '|Process statistics|'),6)

let me know

Re: Parse out text between two identifiers

Fri, 11 Jul 2014 15:51:16 GMT

Hi Gysbert,

Thank you for the response.

That solution works but the number of characters is not static throughout the field.

The result may not always be 6 characters. Do you happen to have any ideas dealing with a dynamic number of characters returned?

*EDIT*

The subfield suggestion worked like a charm!! Thanks much!