Sponsored Content
Top Forums Shell Programming and Scripting How to search for numbers greater than x? Post 302750763 by castrojc on Wednesday 2nd of January 2013 01:01:43 PM
Old 01-02-2013
How to search for numbers greater than x?

I have a file with multiple fields, example below

Code:
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

Code:
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

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to perform calculations using numbers greater than 2150000000.

Could someone tell me how to perform calculations using numbers greater than 2150000000 in Korn Shell? When I tried to do it it gave me the wrong answer. e.g. I have a ksh file with the contents below: --------------------------------- #!/bin/ksh SUM=`expr 2150000000 + 2` PRODUCT=`expr... (3 Replies)
Discussion started by: stevefox
3 Replies

2. Shell Programming and Scripting

replacing numbers greater than 0 with 1

I have some ASCII files containing numerous numbers. What I'd like to do is replace all numbers greater than 0 with 1. Examples of the numbers include: - 000011 and 000042 Thanks (4 Replies)
Discussion started by: vrms
4 Replies

3. UNIX for Dummies Questions & Answers

need a command to search for numbers greater than 3000

i have a file contains: 13213,A,300 3423,C,200 5563,A,201 3000,A,400 3000,A,402 3000,A,206 3000,A,303 3000,A,200 4233,N,204 i need to search for numbers in the first column are greater than 3000? i have another issue if you can help me? if i want to search in the second or the... (7 Replies)
Discussion started by: takyeldin
7 Replies

4. Shell Programming and Scripting

Search only numbers in a file

Hello team, Suppose I have a file named that has following content: abc123 1897 msxi12 ------------ ######## ((((( rapjagc ))))))) 34229 xxxxxxxxxxxx @@@536 I need those lines that contain only numbers from this file. means -- it should eliminate alphanumber, special characters... (3 Replies)
Discussion started by: singhabm
3 Replies

5. Shell Programming and Scripting

How search a list of numbers from a file

Hi Guys! I have two input files. I want to search each of the numbers (studentid) on inputfile1 from inputfile2 and print the studentid and section that are listed from inputfile1. See the desired output below. inputfile1.txt: studentid 261054689 266605695 269826642 264966513... (2 Replies)
Discussion started by: pinpe
2 Replies

6. Shell Programming and Scripting

search column and delete row if greater than value

Hi, as the title states i need to find a way to search a column for values great than 1000, and if it is, then delete that row. An example 1 7.021 6.967 116.019 4 U 6.980E+07 0.000E+00 e 0 0 0 0 2 8.292 7.908 118.063 3 U 1.440E+07 0.000E+00 e 0 821 814 ... (3 Replies)
Discussion started by: olifu02
3 Replies

7. Shell Programming and Scripting

search file for value greater than 'n' on each line and email

Hi, I need to write a script that will read each line of a CSV file, look for values greater than x seconds and email an alert. For the first part, I have one CSV per day, each line in the CSV has comma separated values. There are a total of 8 fields per line separated by commas. 6th and 7th... (3 Replies)
Discussion started by: ssid
3 Replies

8. Shell Programming and Scripting

Search within file1 numbers from list in file2

Hello to all, I hope somebody could help me with this: I have this File1 (real has 5 million of lines): Number Category --------------- -------------------------------------- 8734060355 3 8734060356 ... (6 Replies)
Discussion started by: Ophiuchus
6 Replies

9. UNIX for Dummies Questions & Answers

Grep lines with numbers greater than 2 digits at the end of the line

I'm trying to grep lines where the digits at the end of each line are greater than digits. Tried this but it will only allow me to specify 2 digits. Any ideas would greatly be appreciated. grep -i '\<\{3,4,5\}\>' file ---------- Post updated at 05:58 PM ---------- Previous update was at 05:41... (1 Reply)
Discussion started by: jimmyf
1 Replies

10. UNIX for Advanced & Expert Users

Search for columns with numbers greater than 70

This helped get me started. https://www.unix.com/unix-for-dummies-questions-and-answers/157026-need-command-search-numbers-greater-than-3000-a.html This is the command I am using. I am trying to find numbers greater than 70 in column 5. I do not know if it is getting confused because there... (6 Replies)
Discussion started by: cokedude
6 Replies
Mail::Field::Date(3)					User Contributed Perl Documentation				      Mail::Field::Date(3)

NAME
Mail::Field::Date - a date header field INHERITANCE
Mail::Field::Date is a Mail::Field SYNOPSIS
use HTTP::Date 'time2iso'; my $field = Mail::Field->new(Date => time2iso()); DESCRIPTION
Represents one "Date" header field. METHODS
Constructors Mail::Field::Date->combine(FIELDS) See "Constructors" in Mail::Field Mail::Field::Date->extract(TAG, HEAD [, INDEX ]) See "Constructors" in Mail::Field Mail::Field::Date->new(TAG [, STRING | OPTIONS]) See "Constructors" in Mail::Field "Fake" constructors $obj->create(OPTIONS) See ""Fake" constructors" in Mail::Field $obj->parse() See ""Fake" constructors" in Mail::Field Accessors $obj->set(OPTIONS) -Option --Default Time undef TimeStr undef Time => SECONDS TimeStr => STRING A string acceptable to Date::Parse. $obj->stringify() See "Accessors" in Mail::Field $obj->tag() Mail::Field::Date->tag() See "Accessors" in Mail::Field Smart accessors $obj->text([STRING]) See "Smart accessors" in Mail::Field $obj->time([TIME]) Query (or change) the TIME (as stored in the field) in seconds. DIAGNOSTICS
Error: Undefined subroutine <method> called Mail::Field objects use autoloading to compile new functionality. Apparently, the mehod called is not implemented for the specific class of the field object. SEE ALSO
This module is part of the MailTools distribution, http://perl.overmeer.net/mailtools/. AUTHORS
The MailTools bundle was developed by Graham Barr. Later, Mark Overmeer took over maintenance without commitment to further development. Mail::Cap by Gisle Aas <aas@oslonett.no>. Mail::Field::AddrList by Peter Orbaek <poe@cit.dk>. Mail::Mailer and Mail::Send by Tim Bunce <Tim.Bunce@ig.co.uk>. For other contributors see ChangeLog. LICENSE
Copyrights 1995-2000 Graham Barr <gbarr@pobox.com> and 2001-2007 Mark Overmeer <perl@overmeer.net>. This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself. See http://www.perl.com/perl/misc/Artistic.html perl v5.16.3 2012-12-21 Mail::Field::Date(3)
All times are GMT -4. The time now is 09:57 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy