Position of character in a string

[johnjustus]

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]

Try this

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

[jpenuliar]

Findoneof()

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/Strin...

Regards,
JP

[johnjustus]

Thanks

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

[johnjustus]

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

Try this

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

[johnjustus]

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

Thanks much Sunny!