topic Re: Extract all string after special character in QlikView

Extract all string after special character

agni_gold — Fri, 28 Dec 2018 13:32:56 GMT

Hi All ,

Input :

A|B|C|D
A|B|C|D|E

Output :

D|E

Thanks

Re: Extract all string after special character

Anil_Babu_Samineni — Fri, 28 Dec 2018 13:35:08 GMT

Why D & E for second row? If only E try this?

SubField(Field, '|', -1)

Re: Extract all string after special character

agni_gold — Fri, 28 Dec 2018 13:37:12 GMT

But i required ,

D|E

like this , otherwise it is so simple.

Thanks

Re: Extract all string after special character

Anil_Babu_Samineni — Fri, 28 Dec 2018 13:39:04 GMT

That is fine, Can you explain your business? Or at least 5 Rows and expected result?

Re: Extract all string after special character

sunny_talwar — Fri, 28 Dec 2018 14:04:40 GMT

There is a special character before B and C too... why only extract D and E?

Re: Extract all string after special character

arjun2b — Thu, 12 Aug 2021 05:04:01 GMT

Hi All,

Even I need help on the same scenario, need all the characters after the 3rd occurrences, 4th occurrence should not be considered.

3rd occurrence of the '|' is before 'D' need all the characters after it. D|E|F or so on need all the string after it.
Thanks in advance..
Regards,
Arjun

Re: Extract all string after special character

cwolf — Tue, 17 Aug 2021 10:33:01 GMT

Test: LOAD F1, Right(F1,Len(F1)-Index(F1,'|',3)) as F2 INLINE [ F1 A|B|C|D|E|F A|B|C|D|E A|B|C A|B|C|D A|B ];