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

S

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
 
D

Duane Hookom

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