On 20 Feb 2003 20:32:19 +1100 Kevin Saenz <[EMAIL PROTECTED]> wrote: > I have a flat file that is comma delimited I would like to add to the > start of every line > > insert into table1 ( > > and append to the end of every line with );
[mlh@localhost mlh]$ cat >animaux fish cat dog [mlh@localhost mlh]$ sed 's/^/insert into table1 (/;s/$/);/' < animaux insert into table1 (fish); insert into table1 (cat); insert into table1 (dog); [mlh@localhost mlh]$ Regards, Matt -- SLUG - Sydney Linux User's Group - http://slug.org.au/ More Info: http://lists.slug.org.au/listinfo/slug
