String function

[#1]

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]

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 · Accepted solution]

You could use Index().

I made a small exemple for you.

Edit: changed to qvw