What is MS-ACCESS equivalent of MS-Excel function "FIND"?

[Shaukat]

I am trying to parse a text of the type: "Diabetes; COPD; LDL". I want to
extract Diabetes and CPD and LDL from this string. In excel you can use left
(or Mid or Right) alongwith FIND function to locate the seperator (; in the
examle string). But Access does not recognise FIND fucntion. How do we parse
the text?
Thanks.
Shaukat

 

[Duane Hookom]

Access/VBA use Instr() rather than Find(). There is also a Split() function
that might meet your needs.

 

[Shaukat]

Thank you very kindly. Instr() function works. I will also try Split()
function.