topic Re: Syntax for instr in QlikView

Syntax for instr

JACKNIEKERK — Sat, 16 Nov 2024 00:24:36 GMT

a field in a tabelrecord wich shows based on 2 options wich i can filter,

option a

a$="INVOICE 200010 CUSTOMERCODE: 1296 KLM SHIPPING

here in VB i can do Code$ = mid$(a$,instr(a$,":")+1), 12)

option b

1296| 200010|KLM SHIPPING

here in VB i can do Code$ = left$(a$,instr(a$,"|")-1)

Now i have to do this qlikview during load something like:

if (option = 'a' , mid(a$,instr(a$,':')+-1),12) as Code,

if (option = 'b' , left(a$,instr(a$,'|')-1) as Code,

Please advice , thank you

marcus_sommer — Mon, 29 Jun 2020 10:52:06 GMT

Just replace instr() with index() and it should work nearly without further adjustments whereby the use of subfield() might be even more suitable.

- Marcus

JACKNIEKERK — Mon, 29 Jun 2020 14:35:17 GMT

Yes , this does the job

if(a = '1300' , left(Reason,index(Reason,'| ',1)-1),Mid(Reason,index(Reason,': ',1)+2,12)) as Code

Thanks a lot

regards Jack