topic Find Text separeted by blank in QlikView

Find Text separeted by blank

hd94 — Sat, 16 Nov 2024 19:41:20 GMT

Hello,

I have field with long text separeted by blank and i want to keep text with value 'SS'

Exemple : 'TOTO TUTU TITI_SS TOTI TUTI_SS TYTY'

I want to keep the first text with "SS" , in my example, i want to keep TITI_SS in other field and not TUTI_SS.

Thank you a lot.

ps : sorry for my english

Re: Find Text separeted by blank

Yousef_Amarneh — Wed, 13 Nov 2019 05:00:37 GMT

If the length of the word is always fixed (length=7 which is 4 chars and underscore and SS) then you can use the below

Right(SubField(YourColumnName,'SS',1),7) as Column1

Re: Find Text separeted by blank

MindaugasBacius — Wed, 13 Nov 2019 07:08:32 GMT

The solution:
=Right(Left('TOTO TUTU TITI_SS TOTI TUTI_SS TYTY', Index('TOTO TUTU TITI_SS TOTI TUTI_SS TYTY', 'SS') + 1),
Len(Left('TOTO TUTU TITI_SS TOTI TUTI_SS TYTY', Index('TOTO TUTU TITI_SS TOTI TUTI_SS TYTY', 'SS') + 1)) - Index(Left('TOTO TUTU TITI_SS TOTI TUTI_SS TYTY', Index('TOTO TUTU TITI_SS TOTI TUTI_SS TYTY', 'SS') + 1), ' ', -1))

Re: Find Text separeted by blank

hd94 — Wed, 13 Nov 2019 10:41:16 GMT

Thank you very much