>I have a need to convert formatted text into a database format. The text is always formatted in the same manner, with specific sections always preceded by a unique phrase such as [name]. The form has no ancillary text that needs to be ignored. All sections would go into a
>text field, with one section going into a memo field.
>
>Can someone who has done something like this just give me some ideas how to approach this problem. Thanks!
There is a product called Monarch (it used to be around $99).
I think it is at
www.datawatch.comMonarch is a powerful Windows-based report mining tool that lets you easily access, extract, and manipulate live data from virtually any existing computer-generated report. Monarch lets non-technical professionals (like managers, analysts and data processing specialists whose work depends on data retrieval) access and manipulate data from virtually any existing computer-generated report. You can read report files downloaded from any mainframe, midrange or client/server environment. You can also search the report files for information, print selected pages, copy and paste information to other applications or create a new database. The extracted data can be filtered, sorted and rearranged. And Monarch's new portable reports feature allows you to quickly distribute reports electronically via the Internet to virtually anyone in your organization. With Monarch, there's no rekeying data from hardcopy reports, then proofing to correct mistakes; no required outside custom programming; and no database security issues, because theres no need to access the central database.