Shell Programming and Scripting

I want to write a shell script in order to retreive some data from a log file that i have written into.

The string that i want to get is the number 2849 (that is located between | | ).

To explain further, this is the result i get after running "grep LOGIN filename.log" but i need to get the number (2849) that emphasises to me the thread number.

the log looks like this:
****
IMI|DEBUG|13.03.2007 11:47:28|2849|1073801408| : IMAP COMMAND RECV: [ABCD8 LOGIN 666664444412341:0:0\irit_aha\3

****

Any help will be appreciated!!

Daniel

Code:

$ echo "IMI|DEBUG|13.03.2007 11:47:28|2849|1073801408| : IMAP COMMAND RECV: [ABCD8 LOGIN 666664444412341:0:0\irit_aha\3" | cut -d"|" -f4
2849

Code:

awk -F"|" '{ print $4}' filename

in sed,

Code:

sed 's/\(.*\)|\(.*\)|\(.*\)|\(.*\)/\1/' filename

You can do it all in awk:

Code:

awk '/LOGIN/{print $4}' FS=\| filename.log

if you have python, here's an alternative:

Code:

python -c "import sys; print sys.stdin.readlines()[0].split('|')[3]" < file

output:

Code:

2849

can i use the command "awk -F"|" '{ print $4}'" and the result to be returned to a variable such as this: (this command will be written in shell)

result= `awk -F"|" '{ print $4}'`
so when i run $result, i will get the desired number?

thx
daniel

No space after '=' and '`'

You have to use it this way,

Code:

result=`awk -F"|" '{ print $4}' filename`

or

Code:

result=`echo <allthoseval> | awk -F"|" '{ print $4}'`

Code:

result=`echo $val | awk -F"|" '{ print $4}'`