--- 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 );
> is there a way I can do this using one command line?
Hi Kevin,
How about this?
awk '{print "insert into table1 (" $0 ")"}' myfile.csv
...mark
P.S.: How do you do it with Sed?
=====
mark a. bell
http://www.users.bigpond.com/m487396
__________________________________________________
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com/
--
SLUG - Sydney Linux User's Group - http://slug.org.au/
More Info: http://lists.slug.org.au/listinfo/slug
