Thanks to all that posted suggestions to handle my problem.
Will try them and let you know in a future posting.

Mac,

Have one question regarding the code that should handle my problem. I noticed that a vb script is part of the code. I extracted this much and the script works fine isolating the 03 account and the 015 dollar amount. My question is, How do I combine all this code to use in my Access 2003 application? Can VBA call a script? And if so, how do I accomplish this? Any help will be appreciated. Thank you.

Tom

VBA is basically VBScript. I use this same code to parse text. It should work fine.


mmcdonal