01-09-2015
Grep on a value in a specific column
I need to grep all records from a file that has 1072 in 3rd column. 1072 can be prefixed by "SBC.", "CLS." or "DPT.". My search is just based on string 1072 in 3rd column. Delimiter in the file is tab. For example:
Input FIle:
"InvType" "Organization" "SBC.10720101" "CP.BUP.NY"
"InvType" "Organization" "SBC.10980101" "CP.BUP.NY"
"InvType" "Organization" "SBC.10720101" "CP.BUP.NY"
"InvType" "Organization" "SBC.10980101" "CP.BUP.NY"
"InvType" "Organization" "SBC.10980101" "CP.BUP.NY"
"InvType" "Organization" "CLS.107201" "CP.BUP.NY"
"InvType" "Organization" "SBC.10980101" "CP.BUP.NY"
"InvType" "Organization" "SBC.10980101" "CP.BUP.NY"
"InvType" "Organization" "SBC.10980101" "CP.BUP.NY"
"InvType" "Organization" "DPT.1072" "CP.BUP.NY"
"InvType" "Organization" "DPT.1098" "CP.BUP.NY"
Desired Results:
"InvType" "Organization" "SBC.10720101" "CP.BUP.NY"
"InvType" "Organization" "SBC.10720101" "CP.BUP.NY"
"InvType" "Organization" "CLS.107201" "CP.BUP.NY"
"InvType" "Organization" "DPT.1072" "CP.BUP.NY"
Please help....I tried something like awk -F "\t" '($3 == 1072) {print $0}' filename
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I am having trouble converting a text file. I have been working for this whole day now, still i couldn't make it.
Here is how the text file looks:
_______________________________________________________
DEVICE STATUS INFORMATION FOR LOCATION 1:
OPER STATES: Disabled E:Enabled ... (5 Replies)
Discussion started by: Issemael
5 Replies
2. Shell Programming and Scripting
Hi,
I have the following text file:
8 T1mapping_flip02 ok 128 108 30 1 665000-000008-000001.dcm
9 T1mapping_flip05 ok 128 108 30 1 665000-000009-000001.dcm
10 T1mapping_flip10 ok 128 108 30 1 665000-000010-000001.dcm
11 T1mapping_flip15 ok 128 108 30... (2 Replies)
Discussion started by: goodbenito
2 Replies
3. UNIX for Dummies Questions & Answers
Hey Guys, to keep it simple, I have an idFile:
1006006
1006008
1006011
1007002
......
and famFile:
1006 1006001 1006016 1006017 1
1006 1006006 1006016 1006017 1
1006 1006007 0 0 2
1006 1006008 1006007 1006006 2
1006 1006010 1006016 1006017 2
1006 1006011 1006016 1006017 1
1006... (2 Replies)
Discussion started by: Zoho
2 Replies
4. Shell Programming and Scripting
Hi everybody,
I'd like to think I've been through the search tool not only on this site, but also on google too, but I haven't been able to find what I was looking for. If I might've missed something on this forum, please slap me in the face with a link that you consider useful for my query :D
... (4 Replies)
Discussion started by: dilibau
4 Replies
5. Shell Programming and Scripting
Suppose i have the following data :
cat file.txt
12431,123334,55353,546646,14342234,4646,35234
123123,3535,123434,132535,1234134,13535,123534
123213,545465,23434,45646,2342345,4656,31243
2355425,2134324,53425,342,35235,23434,234535
3423424,234234,65465,,2344,35436,234524,234... (7 Replies)
Discussion started by: Ravi Tej
7 Replies
6. Shell Programming and Scripting
Hello....
Pls help me (and sorry my english) :)
So
I have a file (test.txt) with 1 long line.... for example:
isgc jsfh udgf osff 8462 error iwzr 653 idchisfb isfbisfb sihfjfeb isfhsi gcz eifh
How to print after the "error" word the 2nd 4th 5th and 7th word??
output well be:
653 isfbisfb... (2 Replies)
Discussion started by: marvinandco
2 Replies
7. UNIX for Dummies Questions & Answers
I have a large * delimited text file and need to highlight specific columns on specific lines. The file looks similar to this:
ABC*01*00*01*00000 000000 *00000 000000 *35*0*0*0*0*20000*0*0*1*0000*00*4*0*3*0*0*1*0* *35*0000*001*4*1OT2*0148*0*0*0*0*0*0*6A7801B0**TEST1... (1 Reply)
Discussion started by: say170
1 Replies
8. Shell Programming and Scripting
I have an xml file dumped from rrd file, that I want to "patch" so the xml file doesn't contain any blank hole in the resulting graph of the rrd file.
Here is the file.
<!-- 2015-10-12 14:00:00 WIB / 1444633200 --> <row><v> 4.0419731265e+07 </v><v> 4.5045912770e+06... (2 Replies)
Discussion started by: rk4k
2 Replies
9. Shell Programming and Scripting
Hello All
I have an input file with data below. I would like to grep and display the data where 3rd column contains string or at least one character. Kindly please help me with this!
Input:
tjfa3|zznpou|224fdd.34.ff3.35 |Tiv|Otj|1
fgduul7|zznikj| ... (7 Replies)
Discussion started by: DoveLu
7 Replies
LEARN ABOUT DEBIAN
bup-join
bup-join(1) General Commands Manual bup-join(1)
NAME
bup-join - concatenate files from a bup repository
SYNOPSIS
bup join [-r host:path] [refs or hashes...]
DESCRIPTION
bup join is roughly the opposite operation to bup-split(1). You can use it to retrieve the contents of a file from a local or remote bup
repository.
The supplied list of refs or hashes can be in any format accepted by git(1), including branch names, commit ids, tree ids, or blob ids.
If no refs or hashes are given on the command line, bup join reads them from stdin instead.
OPTIONS
-r, --remote=host:path
Retrieves objects from the given remote repository instead of the local one. path may be blank, in which case the default remote
repository is used. The connection to the remote server is made with SSH. If you'd like to specify which port, user or private key
to use for the SSH connection, we recommend you use the ~/.ssh/config file.
EXAMPLE
# split and then rejoin a file using its tree id
TREE=$(tar -cvf - /etc | bup split -t)
bup join $TREE | tar -tf -
# make two backups, then get the second-most-recent.
# mybackup~1 is git(1) notation for the second most
# recent commit on the branch named mybackup.
tar -cvf - /etc | bup split -n mybackup
tar -cvf - /etc | bup split -n mybackup
bup join mybackup~1 | tar -tf -
SEE ALSO
bup-split(1), bup-save(1), ssh_config(5)
BUP
Part of the bup(1) suite.
AUTHORS
Avery Pennarun <apenwarr@gmail.com>.
Bup unknown- bup-join(1)