Re: getting the value from text file to xml

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



"Jerry John" <Jerry John@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E4B4BE44-81AA-47CE-BEF0-C6047F3467CA@xxxxxxxxxxxxxxxx
I am working in ASP.NET with C#. I have a text file which contains datas
with delimiters. For example:-

MSH|^~\$|DISCHARGE|CLAY COUNTY MEMORIAL|||200502110939|

I also have an XML file created with predefined tags. Some of the tags
contain child element. I need to pass the data from the text file i.e the
value within the delimiters should be passed to the corresponding tags
within
the XML file. I have done this through hard code. But i need it to be
dynamic. There are also possibilities to add or delete tags from the XML
file
which should not affect the code. I have created the XML using Dataset. So
the addition or deletion of tags can be done through dataset without
affecting the code.

Jerry, sorry not to provide a solution, but did you know there are companies
who do this sort of conversion for a living? There are both products and
services whicch can do this for you - correctly.

A google search for "hl7 xml transform" found 46,000 entries. The first
among them was "CONVERT EDI TO XML" at
http://www.stylusstudio.com/convert_edi_to_xml.html. I found it useful for
understanding the nature of the problem, even though I'm not personally
interested in the solution (not yet - we have people for that!)


John


.



Relevant Pages

  • Re: Getting NASM from C
    ... > format we were going to edit it in... ... all XML is? ... HTML is a specific "subset" of XML for displaying ... it's a text file with "tags" inside ...
    (alt.lang.asm)
  • Re: Gotta start somewhere ... how many of us are really out there?
    ... if you are thinking of using XML ... pure shell commands ... ... or whatever XML tags you want to use using the acutal ... accompish all this in hindsight,as all the commands ...
    (freebsd-questions)
  • Re: Read binary data file
    ... I think its use is quite industry-dependent: I've never seen it used in financial messaging (that's more likely to use SWIFT formats, which are tagged text) but its common in the telecommunications industry. ... Compared with XML its a LOT more compact (tags are one byte, fixed length fields don't have terminators, variable length fields are preceded by a one or two byte length) and it has a number of predefined field types as well as arrays. ...
    (comp.lang.java.programmer)
  • Re: xml parsing issue
    ... point all data is being created and writing to xml file what I need. ... The output file has the following tags: ... The VLAN tag and attribute get created but a closing tag never does. ...
    (microsoft.public.scripting.vbscript)
  • Re: REZKONV und Apple OS X
    ... only MasterCook XML export format). ... (name of recipe) designates the Name element, ... These tags work with plain-text files or 3rd party XML files. ... There should be only one ingredient per line. ...
    (de.rec.mampf)