Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
Satfish
For second X position :
index('AXBXCXD' , 'X' , 2 )
For third X position :
index('AXBXCXD' , 'X' , 3 )
Best Regards, Bill
Satfish
For second X position :
index('AXBXCXD' , 'X' , 2 )
For third X position :
index('AXBXCXD' , 'X' , 3 )
Best Regards, Bill
Try Index(YourField,'X',n) n = occurence , 2 for second, 3 for third, etc
Thanks you All, I tried with "Find One Of" it worked