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 » How to set delimiters if it's not a character?
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
- Stylus Studio Technical Forum (14621)
-> + External Cascading Style Sheet... (2)
-> + Need help with XML mapping - P... (2)
-> + Convert image to base64 in xsl... (2)
-> + Automation (2)
-> - Changing Default Property valu... (1)
-> + Help in reading cdata using xs... (4)
-> + Ok, I can programatically conv... (2)
-> + How do I prevent the previewer... (2)
-> + Can I programatically convert ... (2)
-> + XML To Flat File - Reverse Eng... (3)
-> + Check for valid attribute valu... (3)
-> + Java.lang.OutOfMemory - when I... (3)
-> + How to convert text in EBCDIC ... (8)
-> + First steps in XSLT mapping (4)
-> + Option to build XSL-FO is not ... (3)
-> + using Adaptor convert XML to e... (2)
-> + Using XML Converter on a Compl... (2)
-> + Java built-in processor needed... (3)
-> + XSL to draw a table (2)
-> - Stylus Studio in c# solutions (1)
-> + entities within schemaLocation... (4)
-> + java runtime error during xslt... (2)
-> + Conversion of XML Doc for RSS ... (2)
-> + Does anyone know how to upgrad... (2)
-> + XML editor corrupts my file (5)
-> + Stylus Studio & Berkeley DB XM... (4)
-> + XSLT for page breakout (2)
-> + How to avoid creating empty el... (2)
-> + Error in converting 945 EDI us... (4)
-> + XML to X12 (invoice 810 edi) (2)
-> - Stylus Studio 2009 Enterprise ... (1)
-> + Stylus Studio 2007 - license d... (2)
-> + XML to X12 conversion error (6)
-> + How to reset JVM (to another j... (2)
-> + How to generate XML sample dat... (2)
-> + Document Path reference after ... (4)
-> + concatenate with xquery (6)
-> + i want to capture the xml tag ... (3)
-> + "View Sample XML" in schema an... (2)
-> + Can't get to Toolbar settings ... (2)
-> + SOAPException (3)
-> + how to patch xml files with wr... (2)
-> + wysiwug xslt editor (2)
-> + XML to Google Charts (10)
-> + XML to HL7 (2)
-> - Outputting this XML (1)
-> + Interpreting XSD Error Message... (2)
-> + converter EDI --> typ = no (8)
-> + License issue (7)
-> + One of the simplest questions ... (3)
-> + xQuery transformation encounte... (2)
-> + Schema Evolution (2)
-> + Preview in Browser button gray... (4)
-> + converter:EDI:val=no AND chr=.... (4)
-> + [XQuery][DB2 JDBC Driver]Unsu... (2)
-> + Need Help Create XML file thro... (4)
-> + Flat file to XML conversion in... (5)
-> - How to set delimiters if it's ... (4)
-> ->How to set delimiters if ...
-> ->How to set delimiters if ...
-> ->How to set delimiters if ...
-> + XSD Validation failing (4)
-> + XSD Validation failing (2)
-> + Web Service Call cannot retrie... (7)
-> + Flat file conversion to XML (2)
-> + Stylus Studio crash (5)
-> + Stylus Studio No Longer loads (2)
-> + How do I print in color? (2)
-> + Integrating Documentum WebPubl... (2)
-> + Stylus Studio crashes on openi... (4)
-> + Change format of XML output fo... (3)
-> + XSLT mapper / Source file not ... (7)
-> + Stylus Studio crashes on start... (3)
-> + Loading GML3.1 (3)
-> + NullPointerException when runn... (5)
-> + Can not open Stylus Studio (3)
-> + macros for custom validation e... (6)
-> + Does Stylus Studio generate XM... (4)
-> + another csv conversion (7)
-> + ADD CVS to Source Control drop... (2)
-> + Automate xquery (6)
-> + Correcting multiple XML docume... (2)
-> + Unable to locate Components\Da... (5)
-> + Runtime Error, Struzzo.exe, Ab... (11)
-> + Convert XML to EDIfact (3)
-> + I don't have the Mapper tab (6)
-> + CSV conversion with null field (3)
-> + Converting a Complex Flat File... (2)
-> - installion in batch mode (1)
-> + Complete Custom Validation Lis... (2)
-> + creating xml from csv flat fil... (9)
-> - need Help Regarding XBRL (1)
-> + Exception FODC0004: file or di... (2)
-> + Activation (2)
-> + java runtime error (2)
-> + connection problem with AS 400... (4)
-> + XML to 837I EDI -- multiple NM... (3)
-> + WYSIWYG in SSv7 (2)
-> - Write into < head /> tags us... (1)
-> + Maximum recursion depth exceed... (2)
-> - Code coverage testing (1)
-> - Passing JavaScript with multip... (1)
-> + preserving white space in XML ... (8)
-- Previous [721-740] [741-760] [761-780] 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
Thomas AllenSubject: How to set delimiters if it's not a character?
Author: Thomas Allen
Date: 21 Jul 2009 11:00 AM
Hi
I've just purchased the Enterprise Edition 2009R2 and even though I've watched the videos I’m finding lots of things I cannot work out so sorry if quite a few questions appear from me.

I'm trying to create a custom EDI > XML Conversion Definition with these problems I cannot workout.

My elements are always the first 10 chars and values all chars afterwards, with a CR/LF as the terminator (cf/lf works ok). I tried a fixed width option but cant see how to specify the width in the properties?

EDIREC10001astringvalue
EDIREC10002MySecondValue
EDIREC10003MyVALUE
etc to convert to:
<EDIREC10001>astringvalue</EDIREC10001>
<EDIREC10002>MySecondValue</EDIREC10002>
<EDIREC10003>MyVALUE</EDIREC10003>

I would also like to map the element names to real names such as :

<EDIREC10003> - <Comments>

Thanks for your help.
Postnext
Tony LavinioSubject: How to set delimiters if it's not a character?
Author: Tony Lavinio
Date: 21 Jul 2009 04:09 PM
If the file is fixed-width, to mark the start of a new field
put the cursor on the first character of the field and right-click.
One of the menu options will be "Begin field in this column".

If you have more than one type of record, consider using the
"Create Node/Pattern" option; this lets you mark each row as being
of a different type and structure based on it matching a certain
pattern you specify.
Postnext
Thomas AllenSubject: How to set delimiters if it's not a character?
Author: Thomas Allen
Date: 21 Jul 2009 05:57 PM
Originally Posted: 21 Jul 2009 05:58 PM
This just doesnt work. I've been at this for hours. Is there any way to get phone support, even if it requires payment?

Posttop
Tony LavinioSubject: How to set delimiters if it's not a character?
Author: Tony Lavinio
Date: 29 Jul 2009 09:20 AM
1. File|New|Custom XML Conversion
2. Choose the input file, set as fixed-width

That's the first step.
Now, you can set up filters and change field names:

3. Right-click on the first row
4. Choose "Add node and pattern"
5. Take the defaults or change the row element name (for example,
to "comments"; then click OK
6. Do the same for each other row

Now you've got separate record layouts for each row, based
on the characters those rows each start with.

Next, split the fields apart in each row:

7. Right-click on the first "a" on the first line
8. Choose "Begin field in this column" from the menu
9. Do the same for each other row, at the position(s) you want

If you do a slow double-click in the schema tree on the
right, you can rename any of the objects in the tree.
   
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.