Shell Programming and Scripting

Are you going to throw in more hidden requirements if we solve this one?

Code:

awk '{ gsub(/,.*/, "", $2); split ($0, a, /:+/); print "|" $1 "|" $2 "|" a[4] "|" a[5] "|" }' file >newfile

There are very old awk versions which might not be able to work with this script; if it doesn't work, see if you have nawk or mawk or gawk or XPG4 awk on your system.

(Actually with my copy of mawk, the last field was wrong when I set OFS="|" so this script is a bit of a workaround.)

Suppose data is available in file "abc.txt" with several lines in the same format as the line you have mentioned above . Loop works fine unless you have "!" in your data .

for i in `cat abc.txt | sed 's: :!:g' `
do
line=`echo $i | sed 's:!: :g'`
d=`echo $line|cut -d" " -f1`
t=`echo $line |cut -d"," -f1 | cut -d" " -f2`
num=`echo $line|cut -d":" -f6`
model=`echo $line | cut -d":" -f8`
echo "|$d|$t|$num|$model|"
done

|2008-05-24|04:11:57|919740012846|Nokia 6600|

this is not the best way ...........but it works