XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
search
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Home » Boards » Stylus Studio Developer Network » Stylus Studio Technical Forum » Flat file with complex layout for each line -> converting to Xml
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
- Stylus Studio Technical Forum (14621)
-> + Specifying EDI Delimiters (2)
-> + Defining 'connection string' f... (9)
-> + Help Programatically Convertin... (2)
-> + Using adapter URL in pipeline. (7)
-> + How to enable EDI functionalit... (2)
-> + Unable to open file with '%2F'... (2)
-> + How to create a dependency gra... (2)
-> + If block (2)
-> + Mapping multiple files within ... (7)
-> + StylusStudio vs Altova vs BizT... (4)
-> + Command line execution (7)
-> + CSS and Styling in X15 (2)
-> + Ignores debug breakpoints in X... (5)
-> + Cursor dissapearing in Text vi... (5)
-> + compile error xquery java styl... (3)
-> + Stylus Studio Setup: Applicati... (10)
-> + Stylus StudioX15 Crashing whe... (4)
-> + Upgrade Stylus 14 to 15 (2)
-> + ACE Broker Download v2.5 (2)
-> + Help creating custom convertor (7)
-> + Problem saving Documentation (5)
-> + Registry keys for Stylus x15 (8)
-> + How to add a value when conver... (10)
-> + Stylus Studio Pro & Ent X15r1 ... (2)
-> + You need to install Java 2 SDK... (4)
-> - How to disable automatic and m... (1)
-> + Does Stylus Studio / DataDirec... (4)
-> + Stylus Studio fails with 'The ... (12)
-> + Struzzo.exe side by side confi... (7)
-> + unable to use converter (5)
-> + How to enable XSD 1.1 for Saxo... (3)
-> + XSD v.1.1 validation and Xerce... (8)
-> + FATAL ERROR: unsupported XML v... (2)
-> + Java Runtime Environment boot ... (2)
-> + Associate XML with Schema (3)
-> + JVM not found in stylus studio... (2)
-> + Change newline to Linux (on Wi... (4)
-> + Indent XML Tags only partially... (2)
-> + dealing with invalid character... (2)
-> + Unable to call Webservice thro... (2)
-> + XML to CSV Video create csv te... (5)
-> + Try to test this product, (2)
-> + How to migrate license? (3)
-> - kepp your settings on X15 upda... (1)
-> + No Topic (2)
-> + XSD validation scalability iss... (2)
-> + Installing documentation in ai... (4)
-> + Stylus Studio is currently una... (2)
-> + Change from SS Pro 2011 to SS ... (2)
-> + Problem with pipeline function... (2)
-> + Min and Max Occurs for Choices... (2)
-> + XSLT without Preview window ou... (3)
-> + How to achieve this transforma... (2)
-> + Licence Authentication Failed (2)
-> - using Oracle V2 for validation... (1)
-> + Steps needed to execute standa... (2)
-> + xsi:noNamespaceSchemaLocation ... (8)
-> + Using Saxon 9.4 and integrated... (4)
-> + "net XML Parser (5)
-> + How to undo in Stylus Studio X... (2)
-> + .RENAME section not loaded cor... (3)
-> + Stylus StudioŽ X14 Release 2 X... (2)
-> + The JVM initialization failed ... (2)
-> + XML schema to XML does not wor... (4)
-> + missing ExtraLines (3)
-> + EDI validation tool (2)
-> + Registering Custom Tool from c... (5)
-> + Setting Default XML Validation... (2)
-> + Project Directory in Custom Do... (3)
-> + Problem with Saxon 9.4.0.4 AVT... (5)
-> + XML To HL7 (3)
-> + Siblings not repeating when mi... (7)
-> + Nesting of records from fixed ... (5)
-> + Licensing (3)
-> + CSV set up to support predefin... (10)
-> + Scripting conversion (2)
-> + Edi/Euritmo automatic conversi... (4)
-> + Have new stylesheet automatica... (3)
-> + Text file to CSV to xml (9)
-> + EDIFACT to XML (4)
-> + About Stylus Studio... dialog ... (5)
-> + Set Stylus as default editor f... (3)
-> + CSV to XML (11)
-> + Indent XML tags no longer work... (9)
-> + XSL code completion moe like o... (3)
-> + xsl:fo - unable to use any fon... (5)
-> + Bug when calling a ms script f... (13)
-> - url schema (1)
-> + Quickbooks invoice to XML (4)
-> + X14 locks up, Unresponsive (4)
-> + Fields missing from middle of ... (2)
-> + Cannot install trial (2)
-> + Text File with Page breaks - H... (8)
-> + Complex transactional CSV mapp... (2)
-> + XML Report (2)
-> - Create an XML feed for videos (1)
-> + word doc (2)
-> + Saving to a UNC path (7)
-> + sharing violation (3)
-> + Convert XML to XML (6)
-- Previous [181-200] [201-220] [221-240] Next
+ Website Feedback (249)
+ XSLT Help and Discussion (7625)
+ XQuery Help and Discussion (2017)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
Topic  
Postnext
poo sinSubject: Flat file with complex layout for each line -> converting to Xml
Author: poo sin
Date: 07 Oct 2005 02:02 PM
Hi!

I am working on a flat file which has comple layout; each line has its own fixed length record layout. Its predefined in specs. For example below 1st lines just represents column numbers for reference

Second line below is the first line in the flat file. In this 1st four character are for 1st field; next 6 characters are gfor seconf field and so forth

Third line has its own predefined fixed length structure but not same as first line.

and so forth.

1234567890123456789012345678901234567890 (only for column referenving)
ad fgh jkl qwertyu bhjk qwe
fgdgfgfdgd gjhjgh gjhgjhgj tryty
f hgfhgfhhfgh gjhg hgjhjg gjjhgjgh hghg

Then there are some n lines that will repeat in the files and form a block

For examlpe: These thre lines will form one block and this block can repeat m times.
line-a1 - its own fixed width defined structure
line-a2 - its own fixed width defined structure
line-a3 - its own fixed width defined structure

Does Stylus Studio offer capability to cut the file line by line by variable width record structures for each line to convert into xml file.

Thanks,
pS
Postnext
(Deleted User) Subject: Flat file with complex layout for each line -> converting to Xml
Author: (Deleted User)
Date: 07 Oct 2005 03:57 PM
From where are you getting this predefined fixed-width row descriptions ? You have to know somehow that line # n have to use RuleN, right ?
Postnext
poo sinSubject: Flat file with complex layout for each line -> converting to Xml
Author: poo sin
Date: 07 Oct 2005 05:07 PM
Yuriv,

>>From where are you getting this predefined fixed-width row descriptions ? You have to know somehow that line # n have to use RuleN, right ?

Fixed-width row description for each line is defined in the internal specification document - this flat file is kind of edi document but proprietary one. Each line is 124 character, no delimiters, no carriage returns, each line has fields whos length is defined in the specs and each line has a different layout.

Yeah we can have RuleN for line# but there are no patterns, it based on width. How do I define the rules based on width for each line.

Thanks,
pS
Postnext
Tony LavinioSubject: Flat file with complex layout for each line -> converting to Xml
Author: Tony Lavinio
Date: 09 Oct 2005 09:37 PM
Handling fixed-width fields within a record, where the field layout
changes by the pattern, is not available in the current release of
Stylus Studio.
In the next release, due shortly, that feature is present.
Postnext
poo sinSubject: Flat file with complex layout for each line -> converting to Xml
Author: poo sin
Date: 10 Oct 2005 12:08 PM
Hello Tony,

When is the next relase that will have fixed width support within the record is expected to be available to the customers.

Thanks,
pS
Postnext
Tony LavinioSubject: Flat file with complex layout for each line -> converting to Xml
Author: Tony Lavinio
Date: 12 Oct 2005 12:13 AM
We plan to release before the end of the year.
Postnext
Miriam BermanSubject: Flat file with complex layout for each line -> converting to Xml
Author: Miriam Berman
Date: 07 Jun 2006 02:14 PM
I am working with a fixed-width file that I would like to convert to XML.

Each line of the file starts with a tag that determines the file layout of that line, e.g. if the line starts with "Inv " in characters 1-6 it is the Invoice Header information, and would have one layout for that line. If it starts with "Cust " in characters 1-6 it is the Customer information and would need a different fixed layout for that line. If it starts with "Item " in characters 1-6 it is the line item information - and there may be multiple of this type of line.

Can Stylus Studio be used to convert a file like this into XML format?
Posttop
Tony LavinioSubject: Flat file with complex layout for each line -> converting to Xml
Author: Tony Lavinio
Date: 08 Jun 2006 09:49 AM
See http://www.stylusstudio.com/SSDN/default.asp?action=9&read=5181&fid=23

   
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.