Text file pre-processor 
Author Message
 Text file pre-processor

IB>: I have a HUGE text file that I need imported into a database.

IB>: I would like to cut the individual lines in the test file and place tabs
IB>: between all the relavent information, which should then be easier to
IB>: import.

IB>: basically, I'm wondering of there are any shareware programs out there
IB>: which are screen oriented, and simply take a text file and cut it up into
IB>: tab delimited records.

IB>: Basically I would like the program's screen to look like this.

IB>:            Rec1     Rec2   Rec3       Rec4

IB>:          |aaaaaa|bbbbbbb|ccccccccc|dddddddddd|
IB>:          |aaaaaa|bbbbbbb|ccccccccc|dddddddddd|
IB>:          |aaaaaa|bbbbbbb|ccccccccc|dddddddddd|
IB>:          |aaaaaa|bbbbbbb|ccccccccc|dddddddddd|
IB>:          |aaaaaa|bbbbbbb|ccccccccc|dddddddddd|
IB>:          ^      ^       ^         ^          ^
IB>:        Lines are movable, and program automatically calculates start
IB>:        and stop position for each record.  You can mark the records you
IB>:        want to extract then the program extracts all marked fields
IB>:        into a tab delimited file, or possibly a .dbf file.
IB>:

IB>: The reason I'm looking for something screen oriented is I do alot of
IB>: importing like this...and the database I have is set up to ask me start an
IB>: stop positions of each record, then it imports them into its database.

IB>: Does anybody know of a program like this?

IB>: Thanks in advance

IB>: Sean
IB>: -------------
IB>:     Sean T. Finney            |  Notice: All speling and/or grametical
IB>errers

IB>interpherance.

Borland has a program that does exactly this.  It's called FLIMPORT.
You set the start and stop positions and it imports into Paradox
databases.  It will CREATE/OVERWRITE/APPEND.  And it will keep the
configuration for future use.  It's available from Borland's BBS for
downloading.

Ashar



Sat, 24 Aug 1996 04:42:40 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Text file pre-processor

2. DTS Package - Pre-process Text File?

3. ecpg problem : pre-processor translated long constant to char

4. ecpg problem : pre-processor translated hex constant to char

5. ecpg problem : pre-processor translated long constant to char

6. Pre-Processor on MS-Windows ?

7. Saving comments from the Informix ESQL/COBOL Pre-Processor

8. Failed to Append a Text file into another Text file by Using DTS in SQL2000

9. Finding one line in a text file and copying it over to another text file

10. Text file records comparaison against a Master text file

11. Text file records comparaison against a Master text file

12. Reading from a text file and writing toa text file from Vis Bas 6.0


 
Powered by phpBB® Forum Software