[asram]

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]

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

[asram]

Sorry...nothing returned by the above command.

[vgersh99]

nawk -f asram.awk myFile

asram.awk:

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

[mike_bike_kite]

Asram

You could also try

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

423
490

Mike

[radoulov]

If you have GNU Awk:

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