Extract Data from a String

N

navyman2u

I have MS Access 2000 and I have an web address in which I am trying to
extract the text between the "=" and the "&" inside a table column. I don't
know if it best to do this in a Query or VBA.

1. Can this be done?
2. If so, which is the best method?
3. And, if using VBA then what do I do next.

I don't have much experience writing VBA so please be specific as possible.
Thanks.
 
O

Ofer Cohen

I'm not sure that what you mean, but try

Mid([FieldName],instr([FieldName],"=")+1,Instr([FieldName],"&")-instr([FieldName],"=")-1)
 
N

navyman2u

Thanks for the help! It solved my dilemma. I appreciate the help!
Mr. Chase

Ofer Cohen said:
I'm not sure that what you mean, but try

Mid([FieldName],instr([FieldName],"=")+1,Instr([FieldName],"&")-instr([FieldName],"=")-1)

--
Good Luck
BS"D


navyman2u said:
I have MS Access 2000 and I have an web address in which I am trying to
extract the text between the "=" and the "&" inside a table column. I don't
know if it best to do this in a Query or VBA.

1. Can this be done?
2. If so, which is the best method?
3. And, if using VBA then what do I do next.

I don't have much experience writing VBA so please be specific as possible.
Thanks.
Click to expand...
Click to expand...
 
Top