Sponsored Content
Top Forums Shell Programming and Scripting How to append two files with common field. Post 302339727 by aigles on Friday 31st of July 2009 08:27:51 AM
Old 07-31-2009
Please show the the required result from your sample datas.

Jean-Pierre.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Help with complex merg of files with common field

Please help, I am new to shell Programming. I have three files each containg a unique text (key) field (e.g. ABCDEF, XCDUD as shown below), line return followed by some data of which there can be more then one instance. In addition, in some cases there may be no data but only a key field. Please... (18 Replies)
Discussion started by: gugs
18 Replies

2. Shell Programming and Scripting

Join file contents via common field

I have 2 files with a common parm - Jobname File 1 0507 1202 JOBA 0507 1302 JOBB 0507 1452 JOBC 0507 1552 JOBA 0507 1553 JOBA File2 JOBA abcdefg server4 JOBB defghij server22 JOBC vwxyz12 server55 I would like to take each line from File1 and match the jobname with the jobname... (8 Replies)
Discussion started by: Northerner
8 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

join files based on a common field

Hi experts, Would you please help me with this? I have several files and I need to join the forth field of them based on the common first field. here's an example... first file: 280346 39.88 -75.08 547.8 280690 39.23 -74.83 538.7 280729 40.83 -75.08 499.2 280907 40.9 -74.4 507.8... (5 Replies)
Discussion started by: GoldenFire
5 Replies

5. UNIX for Dummies Questions & Answers

compare two files based on common field in unix

I have two files in UNIX. 1st file is Entity and Second File is References. 1st File has only one column named Entity ID and 2nd file has two columns Entity ID | Person ID. I want to produce a output file where entity id's are matching in both the files. Entity File 624197 624252 624264... (4 Replies)
Discussion started by: PRS
4 Replies

6. Shell Programming and Scripting

Merging CSV fields based on a common field

Hi List, I have two files. File1 contains all of the data I require to be processed, and I need to add another field to this data by matching a common field in File2 and appending a corresponding field to the data in File1 based on the match... So: File 1:... (1 Reply)
Discussion started by: landossa
1 Replies

7. UNIX for Dummies Questions & Answers

how to join two files using "Join" command with one common field in this problem?

file1: Toronto:12439755:1076359:July 1, 1867:6 Quebec City:7560592:1542056:July 1, 1867:5 Halifax:938134:55284:July 1, 1867:4 Fredericton:751400:72908:July 1, 1867:3 Winnipeg:1170300:647797:July 15, 1870:7 Victoria:4168123:944735:July 20, 1871:10 Charlottetown:137900:5660:July 1, 1873:2... (2 Replies)
Discussion started by: mindfreak
2 Replies

8. Shell Programming and Scripting

Compare a common field in two files and append a column from File 1 in File2

Hi Friends, I am new to Shell Scripting and need your help in the below situation. - I have two files (File 1 and File 2) and the contents of the files are mentioned below. - "Application handle" is the common field in both the files. (NOTE :- PLEASE REFER TO THE ATTACHMENT "Compare files... (2 Replies)
Discussion started by: Santoshbn
2 Replies

9. UNIX for Dummies Questions & Answers

Values with common field in same line with awk

Hi all ! I almost did it but got a small problem. input: cars red cars blue cars green truck black Wanted: cars red-blue-green truck black Attempt: gawk 'BEGIN{FS="\t"}{a = a (a?"-":"")$2; $2=a; print $1 FS $2}' input But I also got the intermediate records... (2 Replies)
Discussion started by: beca123456
2 Replies

10. UNIX for Beginners Questions & Answers

Awk: output lines with common field to separate files

Hi, A beginner one. my input.tab (tab-separated): h1 h2 h3 h4 h5 item1 grpA 2 3 customer1 item2 grpB 4 6 customer1 item3 grpA 5 9 customer1 item4 grpA 0 0 customer2 item5 grpA 9 1 customer2 objective: output a file for each customer ($5) with the item number ($1) only if $2 matches... (2 Replies)
Discussion started by: beca123456
2 Replies
datas(3U)						    InterViews Reference Manual 						 datas(3U)

NAME
ColorData, GSData, MobilityData, MoveData, VoidData - Data subclasses for storing common undo information SYNOPSIS
#include <Unidraw/Commands/datas.h> DESCRIPTION
The Unidraw library predefines several Data subclasses for storing common undo information: ColorData stores two PSColors (usually repre- senting foreground and background colors), while GSData stores a complete set of graphics state in a FullGraphic object. MobilityData stores the mobility and graphics state information needed to undo a change in mobility. MoveData stores a horizontal and vertical distance. VoidData stores a void pointer as a useful alternative to deriving trivially from Data just to store one word of information. COLORDATA PUBLIC OPERATIONS
ColorData(PSColor*, PSColor*) Create a ColorData instance, supplying the PSColor objects it stores. GSDATA PUBLIC OPERATIONS
GSData(Graphic*) Create a GSData instance, supplying the Graphic object from which to copy a complete set of graphics state. The GSData constructor copies this information into its _gs member, from whence it can be retrieved later. MOBILITYDATA PUBLIC OPERATIONS
MobilityData(Mobility, Graphic*) Create a MobilityData instance, supplying the mobility and a Graphic object from which to copy a complete set of graphics state. The MobilityData constructor copies the graphic into its _gs member, from whence it can be retrieved later. MOVEDATA PUBLIC OPERATIONS
MoveData(float, float) Create a MoveData instance, supplying two floating point numbers that normally represent horizontal and vertical movement. VOIDDATA PUBLIC OPERATIONS
VoidData(void*) Create a VoidData instance, supplying a pointer to an object of unknown type. SEE ALSO
Data(3U), Graphic(3U), globals(3U) Unidraw 24 January 1991 datas(3U)
All times are GMT -4. The time now is 03:25 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy