10-14-2009
Complicated Join command!
Hi I have a serious issue when trying to join to files
so I have two files, one for meals and one for people
Meal1:Turkey:Potato Chips:Twinkie:Coke:5.95
Meal2:Ham & Cheese
oritos:Cookie:Sprite:6.49
Meal3:Vegetarian:Cheese Crackers:Brownie:Pepsi:5.75
Meal4:Tuna:Cheese Puffs:Eclair
iet Coke:6.95
1234:John:Smith:Meal1:103
2345:Bob:Brown:Meal3:155
3456:Susan:Jones:Meal2:215
4567:Betty:Boop:Meal2:444
5678:Abbie:Normal:Meal3:122
6789:Carla:Carmes:Meal4:212
7890
avid
ork:Meal1:355
8901:Joe:Johnson:Meal3:246
9012:Karen:Kook:Meal1:364
what im trying to do is join the two
i've tried
[join -1 4 -2 1 -t: people meals > orders]
but it does not seem to work, can anyone help please
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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
2. Shell Programming and Scripting
Hi,
I am trying to use join command for two files of size greater than 1 GB.
join -t , -1 2 -2 1 -o 1.1,1.2,1.3,1.4,1.5,1.6,1.7,1.8,1.9,1.10,1.11,1.12,1.13,1.14,1.15,1.16,1.17,1.18,1.19,1.20,1.21,1.22,1.23 File1 File2 > File3
we are facing space crunch after using these join command.
May i... (0 Replies)
Discussion started by: jerome Sukumar
0 Replies
3. Shell Programming and Scripting
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
I'm trying to set up an alias in .bash_aliases to show just the filenames of the files in a directory, which the following command will do:
ls -l | grep ^- | awk '{print $NF}'
kjb.zip
ap.zip
tor.zip
However when I set up the following alias in .bash_aliases:
alias lf="ls -l | grep ^- |... (16 Replies)
Discussion started by: gencon
16 Replies
5. Shell Programming and Scripting
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
6. Shell Programming and Scripting
hi guys
i m making one alias which will set variable , invoke sqlplus and also set prompt of sqlplus,,i have made successfully upto invoking sqlplus in unix but cant pass command in sqlplus
here is the command
alias sett='export ORACLE_SID=devdb2;sqlplus system/system@test'
now this... (3 Replies)
Discussion started by: tapia
3 Replies
7. Shell Programming and Scripting
Hi all,
In a directory, I have many video files. Example :
As you can see, some of the video files come with a .aspx file (wich
means the video is actually being uploaded and not entirely written on
the FS)
I try to write a bash script that would find all video files in the
... (1 Reply)
Discussion started by: gniagnia
1 Replies
8. UNIX for Dummies Questions & Answers
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
9. UNIX for Dummies Questions & Answers
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
10. UNIX for Dummies Questions & Answers
Hi,
Please explain the working process of join command.
File 1
P B
S A
C AFile2
C B
P A
S DBut the output of join command is...
join File1.txt File2.txt
P B A
S A DBut I guess the output should be
P B A
S A D
C A BPlease correct me,if i am worong or missing some thing.
Thanks (2 Replies)
Discussion started by: satyar
2 Replies
LEARN ABOUT OSX
tk_nameofjoinstyle
Tk_GetJoinStyle(3) Tk Library Procedures Tk_GetJoinStyle(3)
__________________________________________________________________________________________________________________________________________________
NAME
Tk_GetJoinStyle, Tk_NameOfJoinStyle - translate between strings and join styles
SYNOPSIS
#include <tk.h>
int
Tk_GetJoinStyle(interp, string, joinPtr)
const char *
Tk_NameOfJoinStyle(join)
ARGUMENTS
Tcl_Interp *interp (in) Interpreter to use for error reporting.
const char *string (in) String containing name of join style: one of "bevel", "miter", or "round".
int *joinPtr (out) Pointer to location in which to store X join style corresponding to string.
int join (in) Join style: one of JoinBevel, JoinMiter, JoinRound.
_________________________________________________________________
DESCRIPTION
Tk_GetJoinStyle places in *joinPtr the X join style corresponding to string, which will be one of JoinBevel, JoinMiter, or JoinRound. Join
styles are typically used in X graphics contexts to indicate how adjacent line segments should be joined together. See the X documentation
for information on what each style implies.
Under normal circumstances the return value is TCL_OK and interp is unused. If string does not contain a valid join style or an abbrevia-
tion of one of these names, then an error message is stored in interp->result, TCL_ERROR is returned, and *joinPtr is unmodified.
Tk_NameOfJoinStyle is the logical inverse of Tk_GetJoinStyle. Given a join style such as JoinBevel it returns a statically-allocated
string corresponding to join. If join is not a legal join style, then "unknown join style" is returned.
KEYWORDS
bevel, join style, miter, round
Tk Tk_GetJoinStyle(3)