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
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
- Stylus Studio Technical Forum (14621)
-> + DB to XML convertion (6)
-> - Converting: How to handle data... (2)
-> ->Converting: How to handle...
-> + Toss Character Exception (2)
-> + EDI conversion COM segment (5)
-> - SS passing invalid CALS table ... (1)
-> + Carrier Related EDI SAP questi... (2)
-> + How to generate 1 output XML f... (2)
-> + Urgent Eval: How2 w/ Possibly ... (4)
-> + Preview Problems (7)
-> + Mapping to EDIFACT ORDERS UNT0... (8)
-> + Deploying Conversion XML to ED... (2)
-> + Use EDI Adapter within Sap BC (3)
-> + Uninstall->instal entepr. 2007 (2)
-> - xml data to sql 2000 table (1)
-> - Convert from Oracle DB to XML ... (1)
-> + NTFShardlink broken (5)
-> + Can't get catalog to work (3)
-> + Only One of each EDI segment g... (3)
-> + convert (2)
-> + convert (4)
-- Previous [1861-1880] [1881-1900] [1901-1920] 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
alex muirSubject: Converting: How to handle data over two lines seperated by quotes.
Author: alex muir
Date: 13 Dec 2006 02:00 PM
Originally Posted: 13 Dec 2006 01:59 PM
I Attached a warning file from environment canada that I would like to parse into an XML file. Here is an part of it that gives me problems with the converter:

OMNI_INITIALS=CARLSEN
OMNI_DISCUSSION="
UN FRONT FROID ENVAHIT L'OUEST DU MANITOBA CE MATIN. AVEC LA FORTE
HUMIDITE DEJA PRESENTE ET UN FORT COURANT JET EN ALTITUDE, DES ORAGES
VIOLENTS SONT POSSIBLES. DE LA GROSSE GRELE ET DES VENTS DESTRUCTEURS
SONT LES PRINCIPAUX RISQUES.
"
BULLETIN_TEXT_STATUS=COMPLETE


So how do I get the OMNI_DISCUSSION into a tag like <OMNI_DISCUSSION>"</OMNI_DISCUSSION> without having to create a new region as I can't assume the OMNI_DISCUSSION will be on the same row?

Also attached is one of the converters I tried to make do this.


DocumentWarning.conv
Environment Canada Warning Conv file

UnknownMPCN71_CWWG_311647___47004
Environment Canada Warning File

Posttop
Tony LavinioSubject: Converting: How to handle data over two lines seperated by quotes.
Author: Tony Lavinio
Date: 14 Dec 2006 12:17 PM
The best way to handle this is by post-processing with XSLT
and using positional grouping.

The private email I sent to you included this.
(I hope it reached you!)

   
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.