Parsing fields with delimiters

[tomed]

I have a couple memo fields that store a huge amount of data that I need to parse. The data is seperated by ~. Access help tells me nothing about parsing aside from Left, Right, Mid. Any way of doing this would be greatly appreciated.

 

[jsolutions]

You could use the inStr function to find position of the ~, then use Mid with that position to read those characters into a new string.

A reference for inStr can be found on MSDN at

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/off2000/html/refctInStr.asp

If you are comfortable with Mid, left, Right, etc, then inStr should be pretty clear for you. Let me know if you have any questions.

Jay