Unix delete records(row) that contains non numbers

For example, let's say you have this code(below) and you want to remove rows with non-numeric total charge. total charge is presented in the last column

jersey                     123                     12345
manhattan                455                       aa
Bronx                      345                      567890
queens                   7890                     567890

Hi @jarellkerby, welcome here,

I presume the column for total charge is the last column, but it would be good if you specify a thing like that explicitly when you state your question.

• What have you tried yourself?
• Do you have a utility in mind to accomplish this?
• Do you know how to test for non-numeric values, for example using a regular expression?

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.