fieldindex

[#1]

Hi All,

I want to find the field index of this field but it also contains ' so it is not accepting the itemname for which i want to find out the index. Let me know how to find the index of these kinds of text.

fieldindex( 'itemname', '~KINGCOXTAB 60MG 10'S' )

Thanks and Regards,

Rikab

[#2]

Hi

Try using below format

=fieldindex('itemname','~KINGCOXTAB 60MG 10'&chr(39)&'S'&chr(39))

- Sridhar