Sponsored Content
Full Discussion: join command and delimiters
Top Forums Shell Programming and Scripting join command and delimiters Post 302317701 by manouche on Tuesday 19th of May 2009 04:52:44 PM
Old 05-19-2009
Okay, here is a sample, cut and pasted:

file 1

99997 410
99998 410
100000 410
100001 410

file 2

99997 2009-05
99998 2009-04
99998 2009-04
99998 2009-04
99998 2009-04
99998 2009-04
99998 2009-04
99998 2009-05
99999 2009-04
99999 2009-04
99999 2009-04
99999 2009-04
99999 2009-04
99999 2009-04
99999 2009-04
99999 2009-04
99999 2009-04
100000 2009-04
100000 2009-04
100000 2009-04
100000 2009-04
100000 2009-04
100000 2009-04
100000 2009-04
100000 2009-04
100000 2009-04
100000 2009-04
100000 2009-04
100000 2009-04
100000 2009-04
100000 2009-05
100001 2009-04
100001 2009-04
100001 2009-04
100001 2009-04
100001 2009-04
100001 2009-04
100001 2009-05
100002 2009-04
100002 2009-04
100002 2009-04
100002 2009-04
100002 2009-04
 

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Join command

Hi, I am trying to join 2 files..viz f1: 12~a1 13~a2 112~a3 1112~a4 f2: 12~fa2 13~fa2 112~fa3 1112~fa4 while I join..I just get 2 o/p.. 12~a1~fa2 13~a2~fa2 (4 Replies)
Discussion started by: unisam
4 Replies

2. Shell Programming and Scripting

Using Join Command

Greetings, I am attempting to use the join command to produce a file from 2 sorted comma seperated files. Ex.: FILE 1: jane,dow joe,blow FILE 2: jane,dow,50,50,20 joe,blow,29,53,25 spike,lee,50,91,05 I want the resulting file to be reconds in FILE 2 where the person exists in FILE... (4 Replies)
Discussion started by: Supial
4 Replies

3. Shell Programming and Scripting

join (pls help on join command)

Hi, I am a new learner of join command. Some result really make me confused. Please kindly help me. input: file1: LEO oracle engineer 210375 P.Jones Office Runner ID897 L.Clip Personl Chief ID982 S.Round UNIX admin ID6 file2: Dept2C ID897 6 years Dept5Z ID982 1 year Dept3S ID6 2... (1 Reply)
Discussion started by: summer_cherry
1 Replies

4. Shell Programming and Scripting

join command

Hi my problem is: I've 2 files like: file1: file2 I'd like to get file_out: I mean if the field is different from zero in the first file i want take that field also in the second(no matter if in the second is zero). I tried with the join command but it doesn't work always and i don't... (2 Replies)
Discussion started by: Dedalus
2 Replies

5. Shell Programming and Scripting

need help with join command

Hello, I am using join to merge two files together. The defaults usually works great join file1 file2 However, sometimes file1 or file2 has more keys, which I want to keep. file 1: -1 z 0 a 1 b 2 c file 2: 0 a2 1 b2 2 c2 3 c3 So I do join -a1 -a2 file1 file2 But then you don't... (0 Replies)
Discussion started by: ayu
0 Replies

6. Shell Programming and Scripting

awk command for simple join command but based on 2 columns

input1 a_a a/a 10 100 a1 a_a 20 200 b1 b_b 30 300 input2 a_a a/a xxx yyy a1 a1 lll ppp b1 b_b kkk ooo output a_a a/a 10 100 xxx yyy (2 Replies)
Discussion started by: ruby_sgp
2 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. UNIX for Dummies Questions & Answers

How to use the the join command to join multiple files by a common column

Hi, I have 20 tab delimited text files that have a common column (column 1). The files are named GSM1.txt through GSM20.txt. Each file has 3 columns (2 other columns in addition to the first common column). I want to write a script to join the files by the first common column so that in the... (5 Replies)
Discussion started by: evelibertine
5 Replies

9. Shell Programming and Scripting

Join Two Files, Each With Different Delimiters

Hello All, I am trying to join two files, each with differing delimiters. file1 has doe, john 10.00 60.00 4.00 5.00 doe, jane 10.00 60.00 4.00 5.00 ...while file2 has the following content: doe, johnz 10.00::60.00:4.00:5.00 doe, janet 10.00:60.00::4.00:5.00 Currently, I have join... (2 Replies)
Discussion started by: techieg
2 Replies
LQR_CARVER_GET_IMAGE_TYPE				     LqR library API reference					 LQR_CARVER_GET_IMAGE_TYPE

NAME
lqr_carver_get_image_type - get the image type of a LqrCarver object SYNOPSIS
#include <lqr.h> LqrImageType lqr_carver_get_image_type(LqrCarver* carver); DESCRIPTION
The function lqr_carver_get_image_type returns the image type (i.e. colour model) of the image contained in the LqrCarver object pointed to by carver. SEE ALSO
LqrImageType(3), lqr_carver_new(3), lqr_carver_set_image_type(3), lqr_carver_get_width(3), lqr_carver_get_height(3), lqr_carver_get_ref_width(3), lqr_carver_get_ref_height(3), lqr_carver_get_channels(3), lqr_carver_get_col_depth(3), lqr_carver_get_enl_step(3), lqr_carver_get_orientation(3) COPYRIGHT
Copyright (C) 2007-2009 Carlo Baldassi LqR library 0.4.1 API (3:1:3) 10 Maj 2009 LQR_CARVER_GET_IMAGE_TYPE
All times are GMT -4. The time now is 05:39 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy