[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

Processing huge XML files, generating XML from databases

  • From: Simon Carter <simon_carter@s...>
  • To: xml-dev@l...
  • Date: Sat, 15 Jul 2000 22:42:44 +1100

generate xml file from database


I've developed a Windows GUI stream editor called TextPipe that works in a
similar manner to Unix sed, perl, grep, head, tail, awk, dos2ux, ux2dos etc.
Multiple operations can be chained together, such as end of line conversions
from Unix to DOS, search/replace (exact match, pattern match, sounds like,
edit distance), adding and removing lines and columns etc.

TextPipe is unique in a number of ways:

1. It can select a subset of text and transform the text in the subset eg.
sort lines 3-17, or search and replace in columns 5-50, or MIME encode lines
600-700. Subsets can be search/replace results, groups of lines, groups of
columns, groups of CSV fields, groups of Tab-delimited fields and more.

This means that you can have a high level search for <table>.*</table>, and
inside that search result a new search for <tr>.*</tr> and inside that
search result a new search for <td>.*</td>. Inside this search result you
might convert any found text to Title Case. This means that you can be
extremely selective about the type of table/row/column you match.

2. TextPipe can send SQL commands to multiple databases (via ADO/ODBC), with
the result sets output as CSV, fixed width or XML (TextPipe can generate a
DTD). This can be used to perform lookups based on a selected column, or
data cleansing, or data extract, transform and load (ETL) processes.

3. If TextPipe can't do exactly what you want you can write code in VBScript
or JScript.

4. TextPipe has no limitation on the size or number of files/folders. It
processes all files in approx 5 MB of memory.

If you'd like more information it's available from the URL below. Please let
me know if you find TextPipe useful for XML-related work!

Regards,

Simon
--
End Hours Wasted Manually Editing Data / Text with TextPipe

http://www.crystalsoftware.com.au
Other products: LFNit!, DirSize, BabyShield, DirDate, ZeroIn, Arc Menu,
ClipSize, Clean 'n' Go



PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Buy Stylus Studio Now

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Don't miss another message! Subscribe to this list today.
Email
First Name
Last Name
Company
Subscribe in XML format
RSS 2.0
Atom 0.3
 

Stylus Studio has published XML-DEV in RSS and ATOM formats, enabling users to easily subcribe to the list from their preferred news reader application.


Stylus Studio Sponsored Links are added links designed to provide related and additional information to the visitors of this website. they were not included by the author in the initial post. To view the content without the Sponsor Links please click here.

Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery ™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2013 All Rights Reserved.