That is a good start. The ERE you are using is matching a decimal point followed by two decimal digits (which as you have found only matches lines with exactly two decimal places) at the end of the 2nd field. By negating the match, it finds lines with more than two digits following a decimal point, less than two digits following a decimal point, and fields that do not contain a decimal point. If we use a positive search for three digits following a decimal point (i.e., $2~/[.][0-9][0-9][0-9]/) not anchored to the end of the field, we can find any field that contains three or more decimal digits after a decimal point.

In the 1st post in this thread you said you wanted to print the 1st two fields from lines that matched your criteria. Using print $0 prints the entire input line; not just the 1st two fields.

Try:

Code:

#!/bin/ksh
/usr/xpg4/bin/awk '
BEGIN {	FS = OFS = ","
}
$2 ~ /[.][0-9][0-9][0-9]/ {
	print $1, $2
}' test

and see if that does what you want.

Note that itkamaraj's solution won't necessarily work with input that has extraneous spaces such as:

Code:

xyz, 123456.78 , xxx

which has three characters after the decimal point, but not three digits after the decimal point.