Note:Rec'd Full & Final payment fm Atty...all remaining charges adjusted off per Settlement agreement
The above two examples are two of 1,000's of memo fields that are inside a billing software database that I am interested in importing into an Access Table for better report writing ability. I use ODBC to view the table in Access as it is currently in a FoxPro table. I want to parse it so that Type, Cnum, Srce, Note, and Totl are there own fields. The format of memo fields is four characters to the left of the ":" are the contents description, then the contents. If the description is a Note, the contents can take up multiple rows inside the memo field.