Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Find and copy files with field lower than a value, awk?
Top Forums Shell Programming and Scripting Find and copy files with field lower than a value, awk? Post 302931096 by phaethon on Saturday 10th of January 2015 01:45:43 PM
Old 01-10-2015
Find and copy files with field lower than a value, awk?
Hi all!
I have 10.000 files having generally this format:

Code:
text text text
text num text num text num
text text text GAP number text text
text num text num text num RMS num
text num text num text num
...

what I want is to copy the files if the GAP number is lower than a value e.g. <100

the word gap is always the 12th field and the number is the 13nth

(additionally how can I add a second limittation lets say rms lower than 0.1 and GAP<100)

Thank you in advance for your help and time
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

find files and copy into a directory

hi all, can u please help me in finding all ksh file in directory and including all subdirectories and then copy those files into another directory. thanks in advance -bali (4 Replies)
Discussion started by: balireddy_77
4 Replies

2. Shell Programming and Scripting

awk: find and replace in certain field only, help needed

I got a sample file like this. $ cat test 12|13|100|s 12|13|100|s 100|13|100|s 12|13|100|s I want to replace all 100 by 2000 only in 3rd field using "awk" This is replacing all 100's :-( $ awk -F "|" '{gsub( /100/,"2000");print}' test 12|13|2000|s 12|13|2000|s 2000|13|2000|s... (5 Replies)
Discussion started by: jkl_jkl
5 Replies

3. Shell Programming and Scripting

Merge files of differrent size with one field common in both files using awk

hi, i am facing a problem in merging two files using awk, the problem is as stated below, file1: A|B|C|D|E|F|G|H|I|1 M|N|O|P|Q|R|S|T|U|2 AA|BB|CC|DD|EE|FF|GG|HH|II|1 .... .... .... file2 : 1|Mn|op|qr (2 Replies)
Discussion started by: shashi1982
2 Replies

4. Shell Programming and Scripting

Awk to find duplicates in 2nd field

I want to find duplicates in file on 2nd field i wrote this code: nawk '{a++} END{for i in a {if (a>1) print}}' temp Could not find whats wrong with this. Appreciate help (5 Replies)
Discussion started by: pinnacle
5 Replies

5. Shell Programming and Scripting

How to find files and then copy them to another

I must write any shell script. I want find files which have .txt extension and then copy them to other, whithout this extension, for example: I found linux.out.txt file, and now it must be copy to new, linux.out. So: linux.out.txt -> linux.out ubuntu.config.txt -> ubuntu.config ... (4 Replies)
Discussion started by: piespluto
4 Replies

6. Shell Programming and Scripting

AWK: Pattern match between 2 files, then compare a field in file1 as > or < field in file2

First, thanks for the help in previous posts... couldn't have gotten where I am now without it! So here is what I have, I use AWK to match $1 and $2 as 1 string in file1 to $1 and $2 as 1 string in file2. Now I'm wondering if I can extend this AWK command to incorporate the following: If $1... (4 Replies)
Discussion started by: right_coaster
4 Replies

7. UNIX for Dummies Questions & Answers

How to use wild cards to find files beginning with upper and lower case

Im trying to use wild cards to find files that start with either an upper or lower case letter e.g. list files that beginning with b or B, i also want to sort them by the time they were last modified. e.g latest file created first. At the moment i have the following code that ls -d... (3 Replies)
Discussion started by: parker4001
3 Replies

8. Shell Programming and Scripting

Find and copy these files to particular directory

RedHat Enterprise Linux 5.4 I have some files with the extension .cdp in several directories in various mountpoints(filesystems) . I would like to find and copy all these files into a single directory /u03/diagnore/data. How can I do this ? (3 Replies)
Discussion started by: kraljic
3 Replies

9. Shell Programming and Scripting

Find and delete part of field with awk or sed

I've got a file that looks like this (the whitespace between commas is intentional): 123456789,12,JOHN H DOE ,DOE/JOHN H ,,,DOE/JOHN H ,,,,,123 FAKE STREET ,SPRINGFIELD,XX, I want to strip just the first name out of the third field so it reads "JOHN,". So far I... (6 Replies)
Discussion started by: Scottie1954
6 Replies

10. UNIX for Dummies Questions & Answers

awk command to copy field to bottom records

Hi All, I have a below input, I want to copy the Job_name and Created_by field information to other bottom records as shown in below Output Job_name Created_by Modified_on Modified_by CGI_ACLMIB n38504 2014-05-07 20:40:48 n38504 2014-05-07 20:40:57 n38504 2014-05-08 20:40:57 n48504... (1 Reply)
Discussion started by: somu_june
1 Replies

LEARN ABOUT ULTRIX

disktab

disktab(5)							File Formats Manual							disktab(5)

Name
       disktab - disk description file

Syntax
       #include <disktab.h>

Description
       The file is a simple data base that describes disk geometries and disk partition characteristics.  The format is patterned after the termi-
       nal data base.  Entries in consist of a number of fields separated by colons (:).  The first entry for each disk gives the names  that  are
       known for the disk, separated by vertical bars (|).  The last name given should be a long name fully identifying the disk.

       The following list indicates the normal values stored for each disk entry:
       Name Type Description
       ns   num  Number of sectors per track
       nt   num  Number of tracks per cylinder
       nc   num  Total number of cylinders on the disk
       ba   num  Block size for partition `a' (bytes)
       bd   num  Block size for partition `d' (bytes)
       be   num  Block size for partition `e' (bytes)
       bf   num  Block size for partition `f' (bytes)
       bg   num  Block size for partition `g' (bytes)
       bh   num  Block size for partition `h' (bytes)
       fa   num  Fragment size for partition `a' (bytes)
       fd   num  Fragment size for partition `d' (bytes)
       fe   num  Fragment size for partition `e' (bytes)
       ff   num  Fragment size for partition `f' (bytes)
       fg   num  Fragment size for partition `g' (bytes)
       fh   num  Fragment size for partition `h' (bytes)
       pa   num  Size of partition `a' in sectors
       pb   num  Size of partition `b' in sectors
       pc   num  Size of partition `c' in sectors
       pd   num  Size of partition `d' in sectors
       pe   num  Size of partition `e' in sectors
       pf   num  Size of partition `f' in sectors
       pg   num  Size of partition `g' in sectors
       ph   num  Size of partition `h' in sectors
       se   num  Sector size in bytes
       ty   str  Type of disk (e.g. removable, winchester)

       The entries can be automatically generated with the program.

Files
See Also
       chpt(8), newfs(8)

																	disktab(5)
All times are GMT -4. The time now is 03:25 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy