topic Re: Index function search multiple characters in QlikView

Index function search multiple characters

vesiletaskiran — Wed, 13 Mar 2019 09:01:10 GMT

Hello,

I have a field delimited by either '.', '_' or '-'

is it possible to use index function to return index to one of these? index(field, ',/-/_')

or which function I should use?

Thanks.

Anil_Babu_Samineni — Wed, 13 Mar 2019 09:04:15 GMT

What about

If(Index(field, '.') or Index(field, '_') or Index(field, '-'), field)

vesiletaskiran — Wed, 13 Mar 2019 09:11:46 GMT

Tried but it returns -1

(Index(field, '.') or Index(field, '_') or Index(field, '–') or Index(field, '-'))

Anil_Babu_Samineni — Wed, 13 Mar 2019 09:16:42 GMT

Where are you trying that? I have given to use in Script.

vesiletaskiran — Wed, 13 Mar 2019 09:19:48 GMT

Testing it on straight table first then will implement to script. It looks like below.

=Mid(WO_SLA_TYPE,(Index(WO_SLA_TYPE, '.') or Index(WO_SLA_TYPE, '_') or Index(WO_SLA_TYPE, '–') or Index(WO_SLA_TYPE, '-'))+2)

vesiletaskiran — Wed, 13 Mar 2019 09:28:03 GMT

Giving expected output as below + instead of or, at the end only one of them is true.

=Mid(WO_SLA_TYPE,(Index(WO_SLA_TYPE, '.') + Index(WO_SLA_TYPE, '_') + Index(WO_SLA_TYPE, '–') + Index(WO_SLA_TYPE, '-')))