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 conversion with column names spread over the file
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
- Stylus Studio Technical Forum (14621)
-> - Stylus Studio - Registrar en o... (1)
-> + Stylus Studio - Registrar en o... (2)
-> + Can a pipeline send a file by ... (2)
-> + After Updateing WIN10 to WIN11... (12)
-> + Where do I add the custom java... (3)
-> + Where is the Diagram tab? (5)
-> + Applying XSLT to Word DOCX/XML (2)
-> - CSV conversion via ConvertToXM... (1)
-> + Text symbols in SS not same as... (4)
-> + Exposing xquery as webservice ... (6)
-> + Syntax Identifier (2)
-> + Saving a Converted XML as an X... (5)
-> + Output document cannot be pars... (4)
-> - Archiving output from conversi... (1)
-> + EDIFACT guideline from Stylus ... (3)
-> + CSV file putting all the data ... (5)
-> + Can't install Home version 64b... (5)
-> + presale - Can I covers this sc... (5)
-> + Problem with UNB (5)
-> + Splitting EDIFACT files pipeli... (4)
-- [1-20] [21-40] [41-60] 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
(Deleted User) Subject: Flat file conversion with column names spread over the file
Author: (Deleted User)
Date: 20 Mar 2009 08:19 AM
Dear all,

I have a flat file I want to convert to an xml. Problem is that the layout is field name/field value/field name/field value etc.

I therefore choose fixed width region, but how can I define that each row should start where the text "ProductCodeOEM" is found and that it should take the field value from the next column.

Attached you will find the file concerned.

Thanks,


Cynthia


Unknownart_inf.txt
Flat file conversion
Postnext
John BamptonSubject: Flat file conversion with column names spread over the file
Author: John Bampton
Date: 22 Mar 2009 07:16 AM
You could import the text file to xml then perform a XSL transformation on it to put it in the right format.

If you post your XML that you get I would be happy to write the XSLT for you

Cheers, John Bampton.
Posttop
(Deleted User) Subject: Flat file conversion with column names spread over the file
Author: (Deleted User)
Date: 22 Mar 2009 07:42 AM
Hi John,

Thanks for thinking with me. I asked the customer in the mean time if he could supply me with a file with the field names in the header row and he could.

So we could spare ourselves some time for any new challenge this Sunday will bring us!

Grtz,


Cynthia
   
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.