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

 
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.