Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to find the position of second X in the string ‘AXBXCXD’

Hi All,

could you please help me with formula to find the position of second X  and third X in the string ‘AXBXCXD’.

Thank you,

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Satfish

For second X position :

     index('AXBXCXD' , 'X'  , 2 )

For third X position :

     index('AXBXCXD' , 'X'  , 3 )

Best Regards,     Bill

View solution in original post

3 Replies
Anonymous
Not applicable
Author

Satfish

For second X position :

     index('AXBXCXD' , 'X'  , 2 )

For third X position :

     index('AXBXCXD' , 'X'  , 3 )

Best Regards,     Bill

albertovarela
Partner - Specialist
Partner - Specialist

Try Index(YourField,'X',n)   n = occurence , 2 for second, 3 for third, etc

Not applicable
Author

Thanks you All, I tried with "Find One Of" it worked