Trimming off special characters

[CMcGrann]

I have a field with special characters before and after the info I want
returned. For example:
[["010XQ12345"
["010XQ987654"
I only want what is between the quotes and remove all other characters. Can
I do an update query to do this???

Thanks!

 

[Al Camp]

If you're saying that every string has a (") just before the text you want, and a (")
just after the text you want.
Run an update query against that field (ex. name = [MyStr])...
=Mid([MyStr],InStr([MyStr],Chr(34))+1,Len([MyStr])-InStr([MyStr],Chr(34))-1)

I tested against [["1234ABCD" and ["1234ABCD" and [[[["1234ABCD"