Parsing (Mid, InStr) Question

[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?

 

[pietlinden]

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?

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