Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

String function

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

Tags (1)
1 Solution

Accepted Solutions
dpietersz
Contributor

Re: String function

You could use Index().

I made a small exemple for you.

Edit: changed to qvw

2 Replies
MVP & Luminary
MVP & Luminary

Re: String function

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


talk is cheap, supply exceeds demand
dpietersz
Contributor

Re: String function

You could use Index().

I made a small exemple for you.

Edit: changed to qvw

Community Browser