UNIX for Dummies Questions & Answers

Hi All,

I have one below text file which is seperated by "|". This file has two Rows each and every row has three values(file_header,file_header and invoice_detail). like this

file_header|GEES-EU|343|2007-08-29T07:10:51|SSPF|12|2008|0|0|SSS||
invoice_header|39478-198192-2|250489|BRIDGEWATER108|2007-08-28T00:00:00|1|STANDARD|Receipt Invoic
invoice_detail|39478-198192-2|2|ITEM|1|1|1|AUG-07|5896.45820.000.00.00.000000.000|Advert|856974521|257ZA|zas78

file_header|GEAS-EU|343|2007-08-29T07:10:51|SSPF|12|2008|0|0|SSS||
invoice_header|35818-198192-2|250489|BRIDGEWATER108|2007-08-28T00:00:00|1|STANDARD|Receipt Invoic
invoice_detail|1235-198192-2|2|ITEM|1|1|1|AUG-07|17.121504.45820.000.00.00.000000.000|Advert|123456789|257ZA|zas78

Expected output:
=============

i want cut the above 11th column from the above inpu file (we need to cut the 11th column from invoice_detail row.

856974521
123456789

Thanks in advance,

Thanks,
Siva.P
Bangalore.

Do something like this--

I am not putting the code infact only some logic

for a in $file
do
if ( a%3 =0)
then
str='cut -d"|" -f11'
echo $str
fi
done

Thanks
Namish

Hi Radoulov, I think your example was an answer to my problem. Thanks for this script but it does unfortunatly not work - the output of the script is empty. - Any idea what's missing?

By the way, the usage of uniq -c -fN (-wN) as alternative how method mentioned did also not lead to success for my logfile

cheers, George

Code:

awk '{
	x[$3]++;y[$3]=$0}END{
	for(i in x)
		printf "%s\nThis IP occurred %d time(s)\n",y[i],x[i]
}' file

Hi Radoulov, thanks a lot for your suppport - your script is working for me now!

Real good job

Cheers
George