could you please help me with formula to find the position of second X and third X in the string ‘AXBXCXD’.
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
Retrieving data ...