Reading a particular string value from a file

asram · #1 (**permalink**) 12-24-07, 10:34

Hi, Please help on this. I have several lines in a file in the following format:

{Name=abc,Number=423,CustNo=123}
{Name=abc,Number=890,CustNo=5665}
{Number=423,Name=efg,CustNo=7878}
{Name=abc,Number=423,CustNo=123}
{CustNo=7879,Name=abc,Number=423}
{CustNo=7879,Name=abc,Number=890}

Basically I want to pull all the unique "Number" field values irresepctive of other fields. It can be there anywhere in the line and with different values.
Appreciate your help.

n_i · #2 (**permalink**) 12-24-07, 10:49

Code:

perl -n -e "/Number=(\d+)[,}]/ and printf \"%d\n\",$1;" < myfile

asram · #3 (**permalink**) 12-24-07, 11:32

Sorry...nothing returned by the above command.

vgersh99 · #4 (**permalink**) 12-26-07, 09:00

nawk -f asram.awk myFile

asram.awk:

Code:

BEGIN {
  FS="[{}=,]"
}
{
  for(i=1; i<=NF; i++)
    if($i == "CustNo")
      a[$(i+1)]
}
END {
  for(i in a)
    print i
}

mike_bike_kite · #5 (**permalink**) 12-26-07, 10:55

Asram

You could also try

Code:

cat myfile | grep Number | sed 's/.*Number=//' | sed 's/[^0-9].*//' | sort | uniq

Which just keeps the lines with Number
Removes everything up to and including Number=
Removes anything after the number left over
Sorts and shows the unique values

Which produces

Code:

423
490

Mike

radoulov · #6 (**permalink**) 12-29-07, 13:01

If you have GNU Awk:

Code:

awk '!x[$2]++&&$0=$2' FS="Number=" RS="[,}]" data

Internet Services

Web Development

Digital Marketing

Consumer Tech