03-24-2009
I thought about that, but it takes forever... the files that I'm working with are quite large.
Is there a better way to accomplish this?
Thanks again!
Dave
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hello,
I have a file with tab delimited columns like:
File1
A 2 C R
F 4 D Q
C 9 A B
......
I want to grep out the lines in a second file, File2, corresponding to each line in File1
Can I do this:
while read a b c d
do
grep '$a\t$b\t$c\t$d' File2 >>... (2 Replies)
Discussion started by: Gussifinknottle
2 Replies
2. Shell Programming and Scripting
Hi All,
I just need a quick fix here. I need to delete all lines containing "." in the 6th column.
Input:
1 1055498 . G T 5.46 .
1 1902377 . C T 7.80 .
1 1031540 . A G 34.01 PASS
1 ... (2 Replies)
Discussion started by: Hkins552
2 Replies
3. Shell Programming and Scripting
Hi, I have multiple large files which consist of the below format:
I am trying to write an awk or sed script to remove all occurrences of the 00 record except the first and remove all of the 80 records except the last one.
Any help would be greatly appreciated. (10 Replies)
Discussion started by: nwalsh88
10 Replies
4. UNIX for Dummies Questions & Answers
Gurus,
I am relatively new to Unix scripting and am struck with a problem in my script. I have positional input file which has a FLAG indicator in at position 11 in every record of the file.
If the Flag has value =Y, then the record from the input needs to be written to a new file.However if... (3 Replies)
Discussion started by: gsam
3 Replies
5. Shell Programming and Scripting
I have two files, a keepout.txt and a database.csv. They're unsorted, but could be sorted.
keepout:
user1
buser3
anuser19
notheruser27
database:
user1,2343,"information about",field,blah,34
user2,4231,"mo info",etc,stuff,43
notheruser27,4344,"hiya",thing,more thing,423... (4 Replies)
Discussion started by: esoffron
4 Replies
6. Shell Programming and Scripting
Good day all.
Using basic UNIX/Linux tools, how would you delete a line based on a character found in column 1?
For example, if the CITY name contains an 'a' or 'A', delete the line:
New York City; New York
Los Angeles; California
Chicago; Illinois
Houston; Texas
Philadelphia;... (3 Replies)
Discussion started by: BRH
3 Replies
7. Shell Programming and Scripting
Dear community,
I have to remove duplicate lines from a file contains a very big ammount of rows (milions?) based on 1st and 3rd columns
The data are like this:
Region 23/11/2014 09:11:36 41752
Medio 23/11/2014 03:11:38 4132
Info 23/11/2014 05:11:09 4323... (2 Replies)
Discussion started by: Lord Spectre
2 Replies
8. Shell Programming and Scripting
I am trying to use the two files shown below to either remove or rename contents in one of those files. If in file1.txt $5 matches $5 of file2.txt and the value in $1 of file1.txt is not "No Match" then that value is substituted for all values in $5 and $1 of file2.txt. If however in $1 ... (5 Replies)
Discussion started by: cmccabe
5 Replies
9. UNIX for Beginners Questions & Answers
Hi,
I'd be grateful for your help with the following. I have a file (file.txt) with 10 columns and about half a million lines, which in simplified form looks like this:
ID Col1 Col2 Col3....
a 4 2 8
b 5 6 1
c 8 4 1
d... (4 Replies)
Discussion started by: aberg
4 Replies
10. UNIX for Beginners Questions & Answers
Hello,
I have two files of the following form. I would like to remove from File.A where the first three colum matches values in File.B to give the output in File.C
File.A
121 54321 PQR CAT
122 765431 ABC DOG
124 98765 ZXY TIGER
125 86432 GEF LION
File.B
122 765431 ABC
125 86432 GEF... (4 Replies)
Discussion started by: Gussifinknottle
4 Replies
LEARN ABOUT REDHAT
hexbin
HEXBIN(L) HEXBIN(L)
NAME
hexbin - Macintosh file de-binhexer
SYNOPSIS
hexbin [ - options ] [ files ]
DESCRIPTION
hexbin takes the text files specified in files (or standard input if none is specified) and converts them subject to the options specified.
OPTIONS
In the absence of any options, hexbin takes the specified files and silently converts them into MacBinary format, giving the output files
".bin" extensions and placing them in the current working directory.
-3 Write files in fork format (.info, .data and .rsrc files.)
-f As -3, but empty data and rsrc files are not created.
-r Write resource forks only (.rsrc files.)
-d Write data forks only (.data files.)
-u As -d, but the codes for CR and LF are interchanged, the filename extension is .text.
-U As -u, but there is no filename extension.
-a Write files in AppleShare format. This option is only valid if the program is compiled with support for some form of AppleShare.
The current directory must be a valid AppleShare folder.
-s Write extracted files to standard output in MacBinary format.
-l List every file extracted (and every directory/folder created etc.)
-v Like -l, but more verbose. When this option is specified all lines skipped because they do not belong to the hexified format are
listed (implies -l.)
-i Do not convert, give information only (implies -l.)
-c Do not check whether the hexified lines have equal size. Normally the hexifiers gives text files with equal length line size,
hexbin uses this in its heuristics to determine whether a line must be skipped. There are however hexified files that do not con-
form to that pattern. If this option is specified hexbin will in general be unable to detect whether a line is garbage or not, so
you have to remove the garbage by hand.
-n name
Gives the Unix base file name for the converted files. For files hexified with BinHex 4.0 or compatible hexifiers this flag is not
needed; hexbin will determine the Unix file name based on the Mac file name. For files in dl, hex or hcx format this parameter may
be needed as these formats do not include the Mac filename. Normally hexbin will in those cases base the Unix file name on the text
file name, but that can be overruled with this parameter.
-V Gives the patchlevel of the program, and other information. Other options are ignored and the program quits immediately.
-H Give short information about the options. Other options are ignored and the program quits immediately.
BUGS
As this is a beta release, there may still be some problems.
SEE ALSO
macutil(1)
AUTHOR
Dik T. Winter, CWI, Amsterdam, The Netherlands (dik@cwi.nl)
Parts of the code are based on codes from: ahm (?), Darin Adler, Jim Budler, Dave Johnson, Dan LaLiberte, Jeff Meyer, Guido van Rossum.
3rd Berkeley Distribution October 22, 1992 HEXBIN(L)