Need an instr equivalent

[fcecconi]

I am trying to see if a code is in a series of codes.

If 112 is in 112&113&162&183 set Y else N.  I need to display this in chart

thanks

[Gysbert_Wassenaar]

If(SubstringCount( '112&113&162&18', '112'), 'Y', 'N')

[marcus_sommer]

For this you could use index() or wildmatch() or maybe a substringcount().

- Marcus

[stigchel · Accepted solution]

Have a look at the Index() function e.g.

=if(Index('112&113&162&183', 112)>0,'Y','N')

[fcecconi]

thanks.  this worked as I needed