Parsing (Mid, InStr) Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I know the 1 in the InStr(1,[Field], ",") expression starts at the first
position, and finds the first occurrence of the comma, but what if you need
the second occurrence of the comma?
 
Sharon said:
I know the 1 in the InStr(1,[Field], ",") expression starts at the first
position, and finds the first occurrence of the comma, but what if you need
the second occurrence of the comma?
Click to expand...

put another InStr inside that to find the first one, then start at the
next position
InStr(1,[Field], ",") +1
 
Back
Top