03-22-2010
Thanks for the quick reply. Here are examples from the two files:
file1 contents:
76501792245HSM0000000000000000 06866BET
76501792783HSM0000000000000000 00763ELM
76501805678HSO0000000000000000 30102WES
76501894712HSO0000000000000000 70178PSI
76501895388HOM0001028700000000 06133APP
76501937632HSO0000000000000000 00225ACK
file2 contents:
01792780
01792783
01894712
01894713
01897825
01900407
Per the examples, two records from file1 should be printed to output. (order numbers 01792783 and 01894712).
6 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I am writing a awk script that gathers certain data from certain fields. I needed a awk solution for this, because it will later become a function in the script.
I have the following data that I need output on a single line, but record spans across multilple lines and records are not... (7 Replies)
Discussion started by: timj123
7 Replies
2. Shell Programming and Scripting
Hello. I have big file data like this(part of file):
....
18210102021010000110 47401000000
021001 5166891.16
021011 5166891.16
18210602010020000110 47401000000
020701 8995421.00
021001 8995421.00
021011 8995421.00
030801 .08
18210604011020000110 47401000000
020701 9048.00
021001... (3 Replies)
Discussion started by: maxoff
3 Replies
3. Shell Programming and Scripting
Hi
I have this file with content
ale,4 ,ale,2 ,ale,1 ,ale,2
ale,1 ,ale,7 ,ale,7 ,ale,13
ale,6 ,ale,1 ,ale,1 ,ale,1
ale,1 ,ale,1 ,ale,37 ,ale,1
ale,1 ,ale,1 ,ale,2 ,ale,37
ale,77 ,ale,1 ,ale,53 ,ale,3
ale,5 ,ale,1 ,ale,2 ,ale,40
ale,1 ,ale,1 ,ale,44 ,ale,1... (7 Replies)
Discussion started by: nikhil jain
7 Replies
4. Shell Programming and Scripting
Hi
I am having a csv file like this
ahsh,90.82,add,32424,ahha
hhdh,98.89,hdhdh,92728,neha
hshs,you,97.7,hdhdhd,are,a
jsjsj,wonderful,9788,79.9,aheh
ahdh,95.5,girl, 2737,jolllI need to add width="100" to the value which is greater than 90 like decimal points but less than 100
Output... (5 Replies)
Discussion started by: kshitij
5 Replies
5. UNIX for Dummies Questions & Answers
Hi all. Wondering if someone can help with an awk solution to a problem I'm stumped with.
I have a matrix file with >1000 fields and would like to add another column after each column with a text label. For example:
Input:
$cat file.txt
name col1 col2 col3 coln
aaaa ... (2 Replies)
Discussion started by: torchij
2 Replies
6. UNIX for Beginners Questions & Answers
Hi I have a csv file with as below
sdg-catalog-00000001
sdg-sku-00000317
sdg-sku-00000318
sdg-sku-00000319
sdg-sku-00000320
sdg-catalog-00000002
sdg-sku-00000321
sdg-sku-00000322
sdg-sku-00000323
sdg-sku-00000324
sdg-sku-00000325
sdg-catalog-00000003
sdg-sku-00000326... (3 Replies)
Discussion started by: Raghuram717
3 Replies
LEARN ABOUT DEBIAN
combine
COMBINE(1) COMBINE(1)
NAME
combine - combine sets of lines from two files using boolean operations
SYNOPSIS
combine file1 and file2
combine file1 not file2
combine file1 or file2
combine file1 xor file2
_ file1 and file2 _
_ file1 not file2 _
_ file1 or file2 _
_ file1 xor file2 _
DESCRIPTION
combine combines the lines in two files. Depending on the boolean operation specified, the contents will be combined in different ways:
and Outputs lines that are in file1 if they are also present in file2.
not Outputs lines that are in file1 but not in file2.
or Outputs lines that are in file1 or file2.
xor Outputs lines that are in either file1 or file2, but not in both files.
"-" can be specified for either file to read stdin for that file.
The input files need not be sorted, and the lines are output in the order they occur in file1 (followed by the order they occur in file2
for the two "or" operations). Bear in mind that this means that the operations are not commutative; "a and b" will not necessarily be the
same as "b and a". To obtain commutative behavior sort and uniq the result.
Note that this program can be installed as "_" to allow for the syntactic sugar shown in the latter half of the synopsis (similar to the
test/[ command). It is not currently installed as "_" by default, but you can alias it to that if you like.
SEE ALSO
join(1)
AUTHOR
Copyright 2006 by Joey Hess <joey@kitenet.net>
Licensed under the GNU GPL.
moreutils 2012-04-09 COMBINE(1)