Map it to the appropriate tables/fields in another application. It's basically a way to update one application written by us with data from a 3rd party application. We already do it with comma-delimited files, but the 3rd party app is moving to HL7 standards and we have to comply.

>What you suppose to do with the data after you parse it?
>
>>I'm not sure how big the files will be. One patient is only about 2kb and the way it works is that the service checks for any new charges that have been generated in a parent application and creates the file to be processed by another application. It cycles about every 5 seconds, so I wouldn't expect many patients per file. I should have said that there could be multiple patients earlier, so there could be groups of 7 identifier lines. As I hit each patient, I would append that identifier to the appropriate cursor. That's my thought now anyway. I fogot about the delimiter flag in the APPEND command. Thanks!
>>