SSDN - Line-oriented region problem in CSV file

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

Rick Scofield

Subject: Line-oriented region problem in CSV file
Author: Rick Scofield
Date: 22 Feb 2007 05:49 PM
Originally Posted: 22 Feb 2007 05:44 PM

Hello there,
I have a issue with a conversion adapter that I created that defines four regions within a CSV file. The reason for the regions is that I only want to output some of the fields (not all) and some regions have more than one delimiter type.

My issue is that the conversion looks fine when used with the R1VCHT.csv file, however when you view the conversion with the R1VADI.csv you get a different picture, and even a different view with the R2VADI.csv file. The regions are define as Line-oriented with the CR,LF as Line Terminator. These are not fixed length input files so why do the regions look diffferent for every input file.

Please advise, I have atteched the RproPO.conv and three CSV input files.

Thanks for any help
Rick

RproPO.conv
conv file

R1VADI.csv

R2VADI.csv

R1VCHT.csv

Tony Lavinio

Subject: Line-oriented region problem in CSV file
Author: Tony Lavinio
Date: 23 Feb 2007 11:21 AM

Regions are fixed in size.
Instead of regions, you should be using patterns.
You can have a different row layout based on what the row matches.
So, you could have one layout for rows that begin with "H",...
and another for each type.

Rick Scofield

Subject: Line-oriented region problem in CSV file
Author: Rick Scofield
Date: 27 Feb 2007 12:34 AM

Thanks Tony, I'll give that a try. Seems like I could define different fields and delimters based on the pattern match at the start of the row. I also did not want to output everything in the file which lead me to defining regions. That way I could omit certin sections/fields within the region.

Tony Lavinio

Subject: Line-oriented region problem in CSV file
Author: Tony Lavinio
Date: 27 Feb 2007 09:18 AM

It's easy to omit lines that you don't want - just make sure no
pattern rule matches them. Only lines that match patterns you
give will be output.

Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!

Go to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.