SSDN - Convert flat file with varying record formats

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Conferences

	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 (2016)
	Stylus Studio FAQs (159)
	Stylus Studio Code Samples & Utilities (364)
	Stylus Studio Announcements (113)

Topic

Jay Lessik

Subject: Convert flat file with varying record formats
Author: Jay Lessik
Date: 08 Dec 2005 11:04 AM

See my previous post: http://www.stylusstudio.com/SSDN/default.asp?action=9&fid=23&read=4150&FirstTopic=111&LastTopic=210

The new version of Stylus Studio is supposed to support this but I can't seem to figure out how to do it.

Any ideas?

Thanks!

Minollo I.

Subject: Convert flat file with varying record formats
Author: Minollo I.
Date: 08 Dec 2005 11:37 AM

Consider this example (field separators are tabs):
Type1 2005 12 10
Type1 2004 11 23
Type2 SubtypeA Stylus Studio
Type1 2004 12 1
Type2 SubtypeB Microsoft Winword
Type2 SubtypeA Office

See the short attached movie (it's a flash video; you can open it in your web browser) to see what I did; my output is now:

<?xml version="1.0" encoding="utf-8"?>
<root>
<Date>
<year>2005</year>
<month>12</month>
<day>10</day>
</Date>
<Date>
<year>2004</year>
<month>11</month>
<day>23</day>
</Date>
<Product>
<ProductName>Stylus Studio</ProductName>
</Product>
<Date>
<year>2004</year>
<month>12</month>
<day>1</day>
</Date>
<ProductEx>
<Company>Microsoft</Company>
<Product>Winword</Product>
</ProductEx>
<Product>
<ProductName>Office</ProductName>
</Product>
</root>

Is this similar to what you are trying to do?
Minollo

Minollo I.

Subject: Convert flat file with varying record formats
Author: Minollo I.
Date: 08 Dec 2005 11:38 AM

convert1.swf
convert-to-XML example

Jay Lessik

Subject: Convert flat file with varying record formats
Author: Jay Lessik
Date: 08 Dec 2005 11:52 AM

Hi Minollo,

Thanks for that! That's very close to what I need to do, so I am encouraged! The only difference would be that the file isn't delimited. So for your example, my file would look like this:

Type120051210______SomeData__
Type120041123______SomeData__
Type2SubtypeAStylusStudiossss
Type120041201______SomeData__
Type2SubtypeBMicrosoftWinword
Type2SubtypeAOffice__________

With the _'s being spaces.

The conditions for the formats are slightly more complicated too. It might be something like:

If it starts with Type1 and the SomeData is "SomeData" or "DataSome" and the month is not "12" then it's Format A.

If it starts with Type 1 and the SomeData is "SomeData" and the month is "12" and the year is "2004" then it's Format B.

Based on what your video showed I think this might be possible, just more complicated, heh ;)

Thanks very much for your help, the video was especially helpful! I'll go investigate further and see what I can figure out!

Thanks!

Minollo I.

Subject: Convert flat file with varying record formats
Author: Minollo I.
Date: 08 Dec 2005 12:40 PM

The field where you enter your matching pattern accept regular expressions; so you can discriminate record types in much more complicated contexts than I did in the video.

Also, Convert-to-XML does allow you to handle records where spaces are used as field separators.

Minollo

David Karr

Subject: RE: Convert flat file with varying record formats
Author: David Karr
Date: 08 Dec 2005 03:29 PM

What if I needed something like this to be done at runtime (not in SS),
and also to go in both directions, from "encoded" to XML, and back? I
get the feeling that the "XML Adapters" feature (I don't remember if
that's the name) can do something like this.

> -----Original Message-----
> From: stylus-studio-tech Listmanager
> [mailto:stylus-studio-tech.listmanager@stylusstudio.com]
> Sent: Thursday, December 08, 2005 8:40 AM
> Subject: Convert flat file with varying record formats
>
>
> From: Minollo I.
>
> Consider this example (field separators are tabs):
> Type1 2005 12 10
> Type1 2004 11 23
> Type2 SubtypeA Stylus Studio
> Type1 2004 12 1
> Type2 SubtypeB Microsoft Winword
> Type2 SubtypeA Office
>
> See the short attached movie (it's a flash video; you can
> open it in your web browser) to see what I did; my output is now:
>
> <?xml version="1.0" encoding="utf-8"?>
> <root>
> <Date>
> <year>2005</year>
> <month>12</month>
> <day>10</day>
> </Date>
> <Date>
> <year>2004</year>
> <month>11</month>
> <day>23</day>
> </Date>
> <Product>
> <ProductName>Stylus Studio</ProductName>
> </Product>
> <Date>
> <year>2004</year>
> <month>12</month>
> <day>1</day>
> </Date>
> <ProductEx>
> <Company>Microsoft</Company>
> <Product>Winword</Product>
> </ProductEx>
> <Product>
> <ProductName>Office</ProductName>
> </Product>
> </root>
>
> Is this similar to what you are trying to do?
> Minollo
>
>
> --
> To reply: mailto:stylus-studio-tech.12972@stylusstudio.com
> To start a new topic: mailto:stylus-studio-tech@stylusstudio.com
> To login: http://www.stylusstudio.com/SSDN/
> To (un)subscribe:
> mailto:stylus-studio-tech.list-request@stylusstudio.com
>
>

Minollo I.

Subject: RE: Convert flat file with varying record formats
Author: Minollo I.
Date: 08 Dec 2005 04:08 PM

David,
Stylus Studio Deployment Adapters (http://www.stylusstudio.com/deployment/) will let you use the "convert-to-XML" conversions that you create in Stylus Studio through a Java API - or as extended URI resolvers hooked in your Java XSLT or XQuery processor.

You can find more details in http://www.stylusstudio.com/xml_adapters.html, and you can also take a look at the example shipped with Enterprise Edition (<StylusStudioInstallDir>\examples\Adapters). Also, the video tutorial at http://www.stylusstudio.com/videos/deployment1/deployment1.html shows you how Stylus Studio Deployment Adapters can be easily leveraged even on non Windows platforms.

About bi-directional conversions, the Stylus Studio built-in adapters (like EDI, CSV and others), all support bi-directional use. The user-defined ones (the .conv ones, defined using the convert-to-XML UI module in Stylus Studio) only support nonXML-to-XML.

Minollo

David Karr

Subject: RE: Convert flat file with varying record formats
Author: David Karr
Date: 08 Dec 2005 04:56 PM
Originally Posted: 08 Dec 2005 04:57 PM

I may be missing something, but I interpret this response as a very
convoluted version of "no, you can't do that". I'm talking about a
user-defined non-XML to XML conversion that can be done at runtime, and
can go in both directions. If I understand what you're saying here,
this doesn't provide that capability.

> -----Original Message-----
> From: stylus-studio-tech Listmanager
>
> From: Minollo I.
>
> David,
> Stylus Studio Deployment Adapters ( > href="http://www.stylusstudio.com/deployment/">http://www.styl
> usstudio.com/deployment/) will let you use the
> "convert-to-XML" conversions that you create in Stylus Studio
> through a Java API - or as extended URI resolvers hooked in
> your Java XSLT or XQuery processor.
>
> You can find more details in > href="http://www.stylusstudio.com/xml_adapters.html,">http://w
ww.stylusstudio.com/xml_adapters.html, and > you can also take a
look at the example shipped with
> Enterprise Edition
> (<StylusStudioInstallDir>\examples\Adapters). Also, the
> video tutorial at > href="http://www.stylusstudio.com/videos/deployment1/deploymen
> t1.html">http://www.stylusstudio.com/videos/deployment1/deploy
> ment1.html shows you how Stylus Studio Deployment
> Adapters can be easily leveraged even on non Windows platforms.
>
> About bi-directional conversions, the Stylus Studio built-in
> adapters (like EDI, CSV and others), all support
> bi-directional use. The user-defined ones (the .conv ones,
> defined using the convert-to-XML UI module in Stylus Studio)
> only support nonXML-to-XML.
>
> Minollo

Minollo I.

Subject: RE: Convert flat file with varying record formats
Author: Minollo I.
Date: 08 Dec 2005 05:13 PM

I didn't try to be particularly convoluted, but I guess I succeeded anyway.

Let me try again.

"Can I run a user-defined conversion outside the Stylus Studio UI?"
Yes, you can. You can find references to the Java API that allows you to do that in the previous post.

"Can a user-defined nonXML-to-XML conversion be executed in the other direction, XML-to-nonXML?"
No, it can't. User-defined conversions can only be executed to convert non-XML documents into XML. In contrast, any of the built-in conversions (like EDI - X12/EDIFACT, CSV, ...) can be executed in both directions.

Minollo

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 to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

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.