Hi, as i spool some data into a tmp.log file ${SQL_LOG} which contained the below :

1 row updated.


1 row created.


111
----------
111


Commit complete.

then as i wanted to cut the value of 111 into a variable ,i put as this ksh script and echo it out:
JOB_ID=`head -10 ${SQL_LOG} | -b cut 1-10 '
echo $JOB_ID

but the echo will print as one straight line :
1 row updated. 1 row created. 111 ---------- 111

How do i write ksh script to cut the value 111 out ???

Thanks

Got it, I had steal it from another forum, but I knew it was possible

I always struggle with grep'ing on linenumbers, but there is a very easy function from AWK :

JOB_ID=`awk 'NR>=8 && NR<=9 && /[[0-9]]*/ {print}' ${SQL_LOG}`

NR>=8 Means that linenumber must be above 8
/[[0-9]]* Means that it should match the characters 0123456789

I think it's quiet clear, if you don't make it to understand, please let me know.

Regs David

Hi David,
thanks for your help !
Based on your script as shown below :

JOB_ID=`awk 'NR>=8 && NR<=9 && /[[0-9]]*/ {print}' ${SQL_LOG}`

As your /[[0-9]]* means it will get the line when it encounter any integer value ,right ??

so even if i wanted to cut a sentence in row 10 with 1111 on it , i could use the below script :

JOB_ID=`awk 'NR=10 && /[[0-9]]*/ {print}' ${SQL_LOG}`

Am i right??


thanks a lot!!

You're a quick learner

The question is answered in your original post.

Glad to be of service.


Regs David

Hi,
thanks for your help but when i tried out using the script :

JOB_ID=`nawk 'NR=5 {print}' ${SQL_LOG}`

to cut from this log file :

1 row updated.
1 row created.
111
----------
111
Commit complete.


it will echo out this :
1 row updated. 1 row created. 111 ---------- 111 Commit complete.

instead of just getting out the '111'.

why is it that the log file become one straight line when i echo out and i am unable to cut the 111.

Thanks !

cut -b 1-3
will do what you want.