topic Re: Position of character in a string in QlikView

Position of character in a string

johnjustus — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have an basic question.

I have text object with value as "ABCD%EFG%"

How can I go about finding the position of % and display in another text object?

Thanks,

John

sunny_talwar — Wed, 23 Oct 2019 15:27:49 GMT

Try this

=Index('ABCD%EFG%', '%')

jpenuliar — Wed, 23 Oct 2019 15:29:39 GMT

johnjustus — Wed, 23 Oct 2019 17:52:13 GMT

Thanks

The first occurrence displays as 5 but it is not bringing the second occurrence.

johnjustus — Wed, 23 Oct 2019 17:56:31 GMT

Thanks

I used this expression and it returns 8. But I need the position 4 also.

How can I do that?

=FindOneOf('ABC#DEV#','#',2)

sunny_talwar — Wed, 23 Oct 2019 18:22:41 GMT

Try this

=Concat(If(Index('ABCD%EFG%', '%', ValueLoop(1, 100)) > 0, Index('ABCD%EFG%', '%', ValueLoop(1, 100))), ', ')

johnjustus — Wed, 23 Oct 2019 18:49:33 GMT

Wow. That's an awesome advanced expression and it works.

Thanks much Sunny!