XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Show tree view Topic
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
Bardo BardoSubject: Multiple file regions - dynamic region starting row
Author: Bardo Bardo
Date: 04 Sep 2008 03:14 PM
Hi,

I have a flat file which I am converting to XML. It has a "header" region and multiple "detail" regions, all separated by extra empty lines. I need a way of specifying that the REGION (NOT a row/record) starts at a specific regular expression pattern.
This is because the header region can be of a variable number of rows - hence when there are more rows output, the regions begin parsing the data at the wrong place because they always start parsing at a specific line number or byte position (depending on what has been configured).

Is it possible to make regions dynamically select their starting position, or do they always start at a specific line number/byte number?

Thanks!


DocumentUserGroup.txt
Sample text file

Postnext
Tony LavinioSubject: Multiple file regions - dynamic region starting row
Author: Tony Lavinio
Date: 05 Sep 2008 10:21 AM
You could try something like this.


UnknownUserGroup(1).txt

Posttop
Tony LavinioSubject: Multiple file regions - dynamic region starting row
Author: Tony Lavinio
Date: 05 Sep 2008 10:48 AM
(It would help if I attached the correct file :) )


UnknownUserGroup.conv

 
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! 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

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
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.