02-01-2007
Merge files based on key
Hi Friends,
Can any one help me with merging these file based on two columns :
File1:
A|123|99|SAMS
B|456|95|GEORGE
D|789|85|HOVARD
File2:
S|123|99|NANcY|6357
S|123|99|GREGRO|83748
A|456|95|HARRY|827|somers
S|456|95|ANTONY|546841|RUDOLPH|7263
B|456|95|SMITH|827|BOISE STATE|834
B|789|85|TIM|732643|NEW YORK|90723409
Output should be like this:
A|123|99|SAMS
S|123|99|NANcY|6357
S|123|99|GREGRO|83748
B|456|95|GEORGE
A|456|95|HARRY|827|somers
S|456|95|ANTONY|546841|RUDOLPH|7263
B|456|95|SMITH|827|BOISE STATE|834
D|789|85|HOVARD
B|789|85|TIM|732643|NEW YORK|90723409
Thanks in advance for your help.
S
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I need to join two files based on first column of both files.If first column of first file matches with the first column of second file, then the lines should be merged together and go for next line to check. It is something like:
File one:
110001 abc efd
110002 fgh dfg
110003 ... (10 Replies)
Discussion started by: apjneeraj
10 Replies
2. Shell Programming and Scripting
Hi All,
I have working (Perl) code to combine 2 input files into a single output file using the join function that works to a point, but has the following limitations:
1. I am restrained to 2 input files only.
2. Only the "matched" fields are written out to the "matched" output file and... (1 Reply)
Discussion started by: Katabatic
1 Replies
3. Shell Programming and Scripting
Hi Guys,
After windows died on my netbook I installed Lubuntu and discovered Gawk about a month ago. After using Excel for 10+ years I'm amazed how quick and easily Gawk can process data but I'm stuck with a little problem merging data from multiple lines.
I'm an SEO Consultant and provide... (9 Replies)
Discussion started by: Jamesfirst
9 Replies
4. Shell Programming and Scripting
Hi,
I want to merge the two files based on the key file's columns.
The key file:
DATE~DATE
HOUSE~IN_HOUSE
CUST~IN_CUST
PRODUCT~PRODUCT
ADDRESS~CUST_ADDR
BASIS_POINTS~BASIS_POINTS
...
The other 2 files are From_file & To_file -
The From_file:
DATE|date/time|29|9 ... (9 Replies)
Discussion started by: dips_ag
9 Replies
5. Shell Programming and Scripting
Hi Friends,
I have a file
file1.txt
1|ABC|3|jul|dhj
2|NHU|4|kil|eu
3|hjd|34|hfd|43
file2.txt
1||3|KING|dhj
2|NHU||k|
3|hjd|34|hd|43
i want to merge file1.txt file2.txt based on the column null values in file2.txif there are any nulls in column values , (5 Replies)
Discussion started by: i150371485
5 Replies
6. Shell Programming and Scripting
011111123444 1234 1 20000
011111123444 1235 1 30000
011111123446 1234 3 40000
011111123447 1234 4 50000
011111123448 1234 3 50000
File2:
011111123444,Rsttponrfgtrgtrkrfrgtrgrer
011111123446,Rsttponrfgtrgtr
011111123447,Rsttponrfgtrguii
011111123448,Rsttponrfgtrgtjiiu
I have 2 files... (4 Replies)
Discussion started by: vinus
4 Replies
7. UNIX for Dummies Questions & Answers
Hi, I am trying to selectively merge two files based on keys reported in the 1st column.
File1:
#file1-header1
file1-header2
111 qwe rtz uio
198 asd fgh jkl
165 yxc
789 poi uzt rew
89 lkj
File2:
#file2-header2
file2-header2
165 ghz nko2 ... (2 Replies)
Discussion started by: dovah
2 Replies
8. Shell Programming and Scripting
Hi,
I am struggling with the an awk command to merge two files based on a common key.
I want to append the value from File2 ($2) onto the end of File1 where $1 from each file matches - If no match then nothing is apended
File1
COL1|COL2|COL3|COL4|COL5|COL6|COL7... (3 Replies)
Discussion started by: Ads89
3 Replies
9. UNIX for Beginners Questions & Answers
Hi all
I have two files I need to match record from first file and second file on column 1,8 and and output only match records on file1
File1:
020059801803180116130926800002090000800231000245204003160000000002000461OUNCE000000350000100152500BM01007W0000 ... (5 Replies)
Discussion started by: arunkumar_mca
5 Replies
10. Shell Programming and Scripting
Join and merge multiple files with duplicate key and fill void columns
Hi guys,
I have many files that I want to merge:
file1.csv:
1|abc
1|def
2|ghi
2|jkl
3|mno
3|pqr
file2.csv: (5 Replies)
Discussion started by: yjacknewton
5 Replies
LEARN ABOUT REDHAT
strokes
STROKES(5) File Formats Manual STROKES(5)
NAME
Strokes - X(1) action invocation with simple mouse movements
DESCRIPTION
What are strokes? Simply put, they are a method to invoke program actions with mouse drags. They are defined by the following grid:
1 2 3
4 5 6
7 8 9
Stroke 456 is the horizontal movement from left to right with the stroke button pressed. Holding down the stroke button and tracing out
the letter `C' would be stroke 3214789. Simple, right?
The Stroke library allows you to add strokes to any X(1) program with one simple function call, StrokeInstall(3). For example:
W = XmCreateMessageDialog(Parent,
"StrokeEnabledDialog",
NULL, 0);
StrokeInstall(W);
will enable strokes in the dialog W.
When a stroke is entered the action corresponding to the stroke is called. For the above example the action `Stroke-456' would be called
when `456 is stroked'.
In order to specify a different action you can specify this with the `strokes' resource for the Widget that the strokes have been installed
in. So `*StrokeEnabledDialog.strokes: 456 ManagerGadgetSelect' would call the ManagerGadgetSelect action of the message dialog when 456 is
stroked. The exact syntax is:
Resource.strokes: stroke action [[,stroke action]...]
Resources
strokes: stroke action [[,stroke action]...]
This provides a mapping of strokes to actions. By default the action `Stroke-456' is called for stroke `456'.
strokeSlop: int
This is used to define a buffer zone between the boxes of the grid. The amount of slop tolerated is actually the resulting box
dimension divided by this slop number. Therefore the larger the slop number the more accurate your strokes must be. A value
approaching 3 will make it all but impossible to recognize a stroke. The default value is currently 20. Run the stroke(1) program
with StrokeDebug turned on to show what this means.
strokeDebug: True | False
Turns on `stroke debug mode'. In this mode the strokes are not erased from the screen when the button is released and a grid is
drawn around the stroke. Try the stroke(1) program to see what I mean.
strokeButton: 1 | 2 | 3 | 4 | 5
Specifies the button to be used to draw strokes. By default Btn3 is used.
strokeSound: sound file
If given, the contents of this resource will be provided as an argument to the `PlaySound' action at the conclusion of the stroke.
If the PlaySound action is not defined in your application do not specify this resource. Specifically the following call is made:
XtCallActionProc(W, "PlaySound", NULL, "sound file", 1);
AUTHOR
Rick Scott <rwscott@alumni.uwaterloo.ca>
Check out LessTif at http://www.LessTif.org
SEE ALSO
stroke(1) StrokeInstall(3) StrokeRemove(3) StrokeSetButton(3) StrokeGetButton(3) StrokeSetDebug(3) StrokeGetDebug(3) StrokeSetMapping(3)
StrokeGetMapping(3)
STROKES(5)