Index function search multiple characters

[vesiletaskiran]

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]

What about

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

[vesiletaskiran]

Tried but it returns -1

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

[Anil_Babu_Samineni]

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

[vesiletaskiran]

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

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, '-')))