Search Results

The awk commands you've been using seem to be working correctly, but the results "look" wrong to you because of the way the carriage return before the list of null fields (the string of commas) is...

The file is in dos/win format, reformat the file first with:
tr -d '\r' < dosfile > unixfile