Jay Johengen
Altamahaw-Ossipee, Caroline du Nord, États-Unis
Information générale
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
>>>>>If you create specialized LineToObject methods that match with field namings of target tables then you'd directly do an insert into in those methods. The one I wrote is a generic parser.
>>>>
>>>>Sweet! What is the best way to insert into a cursor from an object?
>>>
>>>I still warn you. The string you are attempting to parse is a medical HL7 delimited string. This format has expanded and become VERY complicated to parse. Image a five dimensional spare string array. If you have not heard of this, you may have trouble getting your mind around HL7. Strongly requimend Google'ing for HL7 format and HL7 parser.
>>>
>>>P.S. I once attempting to write a parser myself and finally used a existing parser after wasting over a month trying to prefect it.
>>
>>Not seeing what's so tough about it. You run through the lines, run through the segments, etc. With help, I've aleady got each line into it's own object. Just a matter of getting that into cursors, using a data dictionary to handle the mapping from the cursors to the correct table/field. Not easy, and kind of tedious, but doesn't seem incredibly hard. Not much different than importing comma-delimited data really, just have more hoops to jump through. Or did I miss your point?
>
>Seems like way too much code... see my reply to Cetin. You just need aptly named and correctly structured tables for each line type.
>
>HTH
>
>thomas
I agree. As I got more responses, it seemed to more simple with each post. I think Cetin's code, with a couple of Peter and Steve's (and know your) ideas will get me pretty close. I'm still getting my head around working with objects in PRG files, so that doesn't help, but it's getting there.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement