topic Re: String function in QlikView

String function

Wed, 06 Mar 2013 14:05:31 GMT

Hi all wizards,

Client have a table looking like this:

AAA, BB, CCC, DDDD, EE

AAA, CCC, DDDD, EE

CCC, DDDD, EE

AAA, BB, CCC, DDDD, EE

AAA, DDDD, EE

AAA, BB, CCC, DDDD

I need to capture DDDD, but it moves all the time as a result of bad input in underlying systems. Which string function can I use to do this?

Can't use Right or Left, Subfield or FindOneOf (as it's not a string) - so what have I left, or am I missing something...

Best regards

Torbjörn Ungvall (@Ungvall)

Senior Business Discovery Manager

Advectas AB

Gysbert_Wassenaar — Wed, 06 Mar 2013 14:11:22 GMT

You'll first have to append the fields together. After that you can use wildmatch or substringcount:

substringcount(Field1&Field2&Field3&Field4&Field5,'DDDD') as DDDD_Match

dpietersz — Wed, 06 Mar 2013 14:14:58 GMT

You could use Index().

I made a small exemple for you.

Edit: changed to qvw