Hi Paul,
assuming that the first three occurances of blanks can be regarded as
field separators you can do:
prompt> cat file.txt | sed \
-e "s/'/'/g" \
-e "s/ */','/" \
-e "s/ */','/" \
-e "s/ */','/" \
-e "s/^/INSERT INTO categories VALUES('/" \
-e "s/$/');/" | mys
I will try that.
Thanks.
- Original Message -
From: "Victor Pendleton" <[EMAIL PROTECTED]>
To: "'Haplo '" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Cc: "'Paul '" <[EMAIL PROTECTED]>
Sent: Thursday, May 27, 2004 1:2
How is the data delimited? You may be able to use the LOAD DATA INFILE
command.
-Original Message-
From: Haplo
To: [EMAIL PROTECTED]
Cc: Paul
Sent: 5/27/04 12:23 PM
Subject: Textfile to table
Hi,
I am trying to add this info into a table and I know there is a way to
do it without using
Hi,
I am trying to add this info into a table and I know there is a way to do it without
using the insert command on every line of data.
201 200 NJ Jersey City
INSERT INTO categories VALUES ('201', '200', 'NJ', 'Jersey City');
there are way too many lines to do by manual inserts.
Any com