skiping last line

u263066 · #1 (**permalink**) 08-08-2006

I have situation

I have to load the datefile through a loader program, and that why I have one loader control file.
My datafile is having first line and last line and inbetween all the data which i need to load into oracle through Sql*loader.

I did not requires last line of data to be loaded into oracle , infact for first line I am able to skip through there inbuilt commond "SKIP =1"

I have tried couple of other options but seems Sql*loader does have limitation and cann't helps in skipping the last line.

alternatively, I am thinking to execute a shell script that remove the last line and put the file as it is with out changing the name and rest of data.

can any one tell me what is adject unix common which I need to fire before executing sql*loader.

I am enclosing my structure of data file:

Code:

03Feb02,14Feb02,A
2039380,AT7000,GB1200,NZD,123456789.00-,07Mar02,INVOICE REFERNCE VVVVVVV,10Feb02,,,EUR,57307148.03-,0.4641879,01,2
2039382,AT1234,GB5000,GBP,674.13-,17Mar02,INVOICE REFERNCE,02Feb02,,,EUR,1077.40-,1.5982100,01,2
................
....
039379,SG1111,GB5000,USD,1423456.00-,07Mar02,INVOICE REFERNCE MMMMMMM,11Feb02,,,SGD,2599168.60-,1.8259564,01,2
2039381,VN5100,GB5000,EUR,741852.00-,07Mar02,INVOICE REFERNCE ZXCVBN,08Feb02,,,SGD,1218046.80-,1.6419000,01,2
END

last line always identified by END.

Dhruva · #2 (**permalink**) 08-08-2006

following two lines will do the jo

Code:

sed -n '$!p' filename>temp
mv temp filename

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
make multiple line containing a pattern into single line	VTAWKVT	Shell Programming and Scripting	13	12-04-2008 06:40 PM
how to delete text from line starting pattern1 up to line before pattern2?	repudi8or	Shell Programming and Scripting	5	04-15-2008 09:25 PM
Unix Script with line number at beginning of each line.	mascorro	Shell Programming and Scripting	5	06-19-2006 04:34 PM
identifying duplicates line & reporting their line number	stresslog	UNIX for Dummies Questions & Answers	5	04-24-2006 12:43 AM
Remove header(first line) and trailer(last line) in ANY given file	madhunk	Shell Programming and Scripting	2	03-13-2006 03:36 PM

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