DataMystic Home Page

 Extract from database

Visit the DataMystic Website
Technical Support Website

Home
End-of-line (EOL) Converter
Replace string
Extract from database
Extract text between delimiters
Convert EBCDIC to ASCII
Sort files
Replace pattern
Replace in line or column range
Replace in Tab range
Replace in CSV range
Add line numbers
Remove blanks
Join files
Extract email addresses
Website logs
Split files
Email Cleanup
Replace delimiter
Common tasks

1. Extract data from database

Note: After this filter is added, you will have to click the Build button to tell TextPipe how to connect to your database. For more help, please click here.
Get data from: A table called
This SQL query:
   

Output mode: Output a header row or XML DTD

CSV delimited
Tab-delimited
Fixed width
XML
A SQL Insert script for table


Do you want the original files to be overwritten? Yes, overwrite the original files with the converted files
No, give the new files the following extension:


(You may be prompted to allow IE to interact with TextPipe - just click Yes)

2. Files and Folders to Process

Drag and drop the files and folders you want processed from Windows Explorer to anywhere in TextPipe's window. Folders automatically get '*.*' added to them to process all files.

You can tailor the file list in a number of ways. To find out how, click the cursor in TextPipe's file grid to select it, then press F1.

3. Begin Processing

 
  Display TextPipe while processing occurs

 


 

Note: These Wizards will not work unless TextPipe Pro is installed. Click here to Download Now!

Other wizards and notes

Home ] End-of-line (EOL) Converter ] Replace string ] [ Extract from database ] Extract text between delimiters ] Convert EBCDIC to ASCII ] Sort files ] Replace pattern ] Replace in line or column range ] Replace in Tab range ] Replace in CSV range ] Add line numbers ] Remove blanks ] Join files ] Extract email addresses ] Website logs ] Split files ] Email Cleanup ] Replace delimiter ] Common tasks ]

 Contact Us   |  Support   |  DataMystic Newsletter
 © 1999-2013 DataMystic. All rights reserved.