how to add ; at the end of last line

crackthehit007 · #1 (**permalink**) 09-26-2009

hi,
i have file which is having large sql query
eg :

Quote:

select * from tab

i am executing this sql file but now i want to add ; after query on same line
i.e. i should look like

Quote:

select * from tab;

any idea how to achieve it ?

Rhije · #2 (**permalink**) 09-26-2009

I am really not sure what you are asking. Could you provide a bit more detail, such as a few lines from the current file (or mock ups), and what you want them to look like ?

crackthehit007 · #3 (**permalink**) 09-26-2009

just wanted to add ; at end of last line !

is it possible via shell script?

radoulov · #4 (**permalink**) 09-26-2009

Yes:

Code:

sed '$s $ ; ' infile > _tmp_ && mv _tmp_ infile

crackthehit007 · #5 (**permalink**) 09-26-2009

ohk good...does it replaces EOF with ; ?
does it means EOF does not exists in updated file ...then i cant read it right ?

radoulov · #6 (**permalink**) 09-26-2009

Just run the commands and check the file content.

rdcwayx · #7 (**permalink**) 09-27-2009

Code:

echo "select * from tab" |awk '{print $0";"}'

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
how do you parse 1 line at a time of file1 ie. line(n) each line into new file	web_developer	UNIX for Advanced & Expert Users	4	06-28-2009 01:07 PM
Compare multiple fields in file1 to file2 and print line and next line	gillesc_mac	Shell Programming and Scripting	7	03-16-2009 06:26 AM
Reading a file line by line and processing for each line	sagarparadkar	Shell Programming and Scripting	6	03-02-2009 11:59 AM
I need suggestion on problem read a file line by line and do stuff	madi3d8	Shell Programming and Scripting	3	01-15-2009 11:33 AM
Deleting Characters at specific position in a line if the line is certain length	Cailet	Shell Programming and Scripting	10	12-17-2008 02:41 PM

Bits Awarded / Charged to radoulov for this Post
Date	User	Comment	Amount
09-27-2009	Anonymous	sed '$s $ ; ' infile > _tmp_	666

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by