topic Multiple TextBetween? in QlikView

Multiple TextBetween?

Anonymous — Mon, 05 Oct 2015 18:46:15 GMT

Hi, I have this in my script right now and it is working.

TextBetween(Description, 'JHI_', ' - ') as Abbreviations

What I'd like to do is say

TextBetween(Description, 'JHI_', ' - ') OR TextBetween(Description, 'JHI_', ' _ ') OR TextBetween(Description, 'JHI_', ' . ') as Abbreviations

However the OR does not work here. Ideas, suggestions? Please help. Thank you.

Re: Multiple TextBetween?

settu_periasamy — Tue, 06 Oct 2015 03:19:50 GMT

Hi,

May be you can try with if condition, like

if(not IsNull(TextBetween(Description, 'JHI_', ' - ')),

TextBetween(Description, 'JHI_', ' - '),

if(not IsNull(TextBetween(Description, 'JHI_', ' _ ')),

TextBetween(Description, 'JHI_', ' _ '),

if(not IsNull(TextBetween(Description, 'JHI_', ' . ')),

TextBetween(Description, 'JHI_', ' . ')))) as Abbreviations

Re: Multiple TextBetween?

sunny_talwar — Tue, 06 Oct 2015 03:22:48 GMT

Not sure, but this might also work:

Alt(TextBetween(Description, 'JHI_', ' - '), TextBetween(Description, 'JHI_', ' _ '), TextBetween(Description, 'JHI_', ' . ') as Abbreviations

Re: Multiple TextBetween?

jagan — Tue, 06 Oct 2015 03:37:18 GMT

Hi,

Try with Alt()

Alt(TextBetween(Description, 'JHI_', ' - '), TextBetween(Description, 'JHI_', ' _ '), TextBetween(Description, 'JHI_', ' . ')) as Abbreviations

OR with If() like below

If(Len(TextBetween(Description, 'JHI_', ' - ')) > 0, TextBetween(Description, 'JHI_', ' - '),

If(Len(TextBetween(Description, 'JHI_', ' _ ')) > 0, TextBetween(Description, 'JHI_', ' _ '),

If(Len(TextBetween(Description, 'JHI_', ' . ')) > 0, TextBetween(Description, 'JHI_', ' . ')))) AS Addbreviations

Hope this helps you.

Regards,

Jagan.

Re: Multiple TextBetween?

preminqlik — Tue, 06 Oct 2015 06:45:23 GMT

ALT() is good as per jagan

Re: Multiple TextBetween?

Anonymous — Tue, 06 Oct 2015 12:12:16 GMT

alt did not work. what is alt?

Re: Multiple TextBetween?

sunny_talwar — Tue, 06 Oct 2015 12:37:14 GMT

Then I would suggest going with the second option listed by Jagan.

If that still doesn't work, I would suggest providing a sample to work with.

Re: Multiple TextBetween?

Anonymous — Tue, 06 Oct 2015 12:39:57 GMT

This worked, thank you

Re: Multiple TextBetween?

Anonymous — Tue, 06 Oct 2015 13:11:28 GMT

Hi so I have another column where I need to search for keywords. For example in this column, Short Description, I need to find the name application however the cells are populated differently.

1. application account updated.

2. The issue was application.

3. application has been updated.

I need to extract the word application.

Thoughts? Thank you.

Re: Multiple TextBetween?

settu_periasamy — Wed, 07 Oct 2015 02:25:59 GMT

Hi,

You can try with WildMatch.. like

if(WildMatch(Short Description],'*Application*'),Your Expression, False Expression) as FieldName