How to search for numbers greater than x?

Shell Programming and Scripting
1

I have a file with multiple fields, example below

File 1:

Field 1|Field 2|Field 3|Field 4|Field 5|Field 6|Field 7|100
Field 1|Field 2|Field 3|Field 4|Field 5|Field 6|Field 7|101
Field 1|Field 2|Field 3|Field 4|Field 5|Field 6|Field 7|102
Field 1|Field 2|Field 3|Field 4|Field 5|Field 6|Field 7|103
Field 1|Field 2|Field 3|Field 4|Field 5|Field 6|Field 7|104
Field 1|Field 2|Field 3|Field 4|Field 5|Field 6|Field 7|105
Field 1|Field 2|Field 3|Field 4|Field 5|Field 6|Field 7|106
Field 1|Field 2|Field 3|Field 4|Field 5|Field 6|Field 7|107
Field 1|Field 2|Field 3|Field 4|Field 5|Field 6|Field 7|108
Field 1|Field 2|Field 3|Field 4|Field 5|Field 6|Field 7|109
Field 1|Field 2|Field 3|Field 4|Field 5|Field 6|Field 7|110
Field 1|Field 2|Field 3|Field 4|Field 5|Field 6|Field 7|111
Field 1|Field 2|Field 3|Field 4|Field 5|Field 6|Field 7|112

I want to be able to do a search through each line and get only the first field of any line that has the last field with a number greater than or equal to "x". For example lets say x=105, I want the output of this script to be

Output:
Field 1|105
Field 1|106
Field 1|107
Field 1|108
Field 1|109
Field 1|110
Field 1|111
Field 1|112
2 
awk -F'|' -v X=105 '$NF>=X{print $1,$NF}' OFS='|' filename

Or simply

awk -F'|' '$NF>=105{print $1,$NF}' OFS='|' filename
1 Like
3

Thanks, now what if I want to change the number from 105? Is there a way to make that number a variable instead?

4

try using bipinajith's first example:

var=105
awk -F'|' -v X=$var '$NF>=X{print $1,$NF}' OFS='|' filename
1 Like
5

ahh, I see. Thank you both