Subject:Text to XML conversion issue Author:Larry Johnson Date:03 Dec 2008 02:20 PM
I'm fairly new to using the .conv files. First let me say thanks for the tutorial videos... they are very helpful. I have a situation that I'm not sure how to handle, though. I have an input file that contains legacy mainframe data. Each line can be no longer than 80 characters. Since that isn't enough room to represent some information, it has a structure similar to the following:
The first number (120, 122) is the record type. The second number is a sub-type which tells me what information is in that row. So, even though it took two rows to represent a 120 record in my example, it is one logical record and I want it to be a single <Record120> element in my output.
Now for the harder part, the 122 records are detail records that belong to the 120 record. Each 120 record can have multiple 122 records. I would like the 122 records to be children of their respective 120 elements in my output. So, I would like my XML to be formatted something like this:
Subject:Text to XML conversion issue Author:Tony Lavinio Date:03 Dec 2008 05:47 PM
The Custom XML Converter module's job is to get the data into
XML. The job of formatting the XML into a shape that is specifically
useful for a given case is left to XSLT or XQuery, which were
designed specifically for transforming XML.
You can use the output of the CXC as input to XSLT by specifying
the filename like this for the XSLT: