[SOLVED] Print rows that has numbers in it

Issue

this is my data - i've more than 1000rows . how to get only the the rec's with numbers in it.

Records | Num

123 | 7 Y1 91

7834 | 7PQ34-102

AB12AC|87 BWE 67

5690278| 80505312

7ER| 998

Output has to be

7ER| 998

5690278| 80505312

I'm new to linux programming, any help would be highly useful to me. thanks all

Solution

A short and simple GNU awk (gawk) script to filter lines with numbers in the second column (field), assuming a one-word field (e.g. 1234, or 12AB):

awk -F'|' '$2 ~ /\y[0-9]+\y/' file

We use the GNU extension for regexp operators, i.e. \y for matching the word boundary. Other than that, pretty straightforward: we split fields on | and look for isolated digits in the second field.

Edit: Since the question has been updated, and now explicitly allows for multiple words in the second field (e.g. 12 AB, 12-34, 12 34), to get lines with numbers and separators only in the second field:

awk -F'|' '$2 ~ /^[- 0-9]+$/' file

Alternatively, if we say only letters are forbidden in the second field, we can use:

awk -F'|' '$2 ~ /^[^a-zA-Z]+$/' file

Answered By - randomir

Answer Checked By - Willingham (WPSolving Volunteer)