0

I have a problem with filter rows with empty row in 4 column.

Input:

1242    2021-11-22     Text     5.0
1242    2021-11-22     Text
1242    2021-11-22     Text     5.0
1242    2021-11-22     Text     5.0
4095    2021-11-22     Text
4095    2021-11-22     Text     5.0
4095    2021-11-22     Text
4095    2021-11-22     Text     5.0
4095    2021-11-22     Text
4095    2021-11-22     Text     5.0

and I want output:

1242    2021-11-22     Text     5.0
1242    2021-11-22     Text     5.0
1242    2021-11-22     Text     5.0
4095    2021-11-22     Text     5.0
4095    2021-11-22     Text     5.0
4095    2021-11-22     Text     5.0

The size of a file is 2.0Gb and number of lines is ~45m.

I have tried these, but none of it worked - it returns empty or same file:

awk -F: '{if($4 != "") print}'
awk -F '$4 != ""'
awk -F , '$4 != "\"\"" {print}'
Improve this question
3
  • What is the delimiter between columns? Space, TAB, comma? Commented Dec 2, 2021 at 19:09
  • Delimeter is TAB Commented Dec 2, 2021 at 19:12
  • 4
    When posting an example of data that includes text it's best to provide some representative text, not just use the word Text everywhere. If your delimiter is tab then setting your delimiter to : or , is obviously not going to work. Commented Dec 2, 2021 at 19:26

2 Answers 2

Reset to default
7 
awk 'NF==4' file

or if your Text can contain blanks then:

awk -F'\t' '$4!=""' file

If that's not all you need then edit your question to provide more truly representative sample input/output included cases that doesn't work for.

Improve this answer
2
  • Why not just awk '$4'? Am I missing a failsafe? Commented Dec 2, 2021 at 21:05
  • 6
    $4 could be the non-empty value zero. Commented Dec 2, 2021 at 21:20
0 
awk '$4 !~ /^$/' filename

1242    2021-11-22     Text     5.0
1242    2021-11-22     Text     5.0
1242    2021-11-22     Text     5.0
4095    2021-11-22     Text     5.0
4095    2021-11-22     Text     5.0
4095    2021-11-22     Text     5.0
Improve this answer

You must log in to answer this question.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.