Sorry for the confusion that I am creating. Let me start from the beginning. These files are tab delimited files. Because there is a confusion with the file names, I will henceforth use the original file names --dlya0908.tab (which I was referring as File1) and tgpr.tab (which I was referring as File2)
I do not have information on how does the source team create the files. It is an external server from which the files are FTPed.
So, dlya0908.tab looks like this :
and tgpr.tab looks like this :
I am trying to join these files like this :
The above command does not give me any result.
When I give
I get
This is wrong because there is a common key here -- 01635163349.
So the output I am looking for is :
I am looking for a way to inner join these files. tgpr.tab is a full dump file while dlya0809 is a daily file.
I hope the information I have given is helpful this time
Hi everybody,
I am hoping somebody here will be either be able to solve my troubles or at least give me a push in the right direction :) .
I am developing a shell script to read in 4 different files worth of data that each contain a list of:
username firstname secondname group score
I... (2 Replies)
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)
Hi guyz
Excuse me for posting simple question
I tried join and sort and other perl commands but failed
I have 2 files. 1st file contain single column with around 6000 values (rows).
Second file contain 2 columns 1st column is the same column (in 1st file) but randomly ordered and second... (5 Replies)
Hello,
Going through book, "Guide to UNIX Using Linux". I am doing one of the projects that has me writing scripts to join files. Here is my pnumname script and I am extracting the programmers names and numbers from the program file and redirecting the output to the file pnn. I then created a... (0 Replies)
So I want to join two files that have a lot of rows
The file named gen1 has 2 columns:
head gen1
1008567 0.4026931012
1119535 0.7088912314
1120590 0.7093805634
1145994 0.7287952590
1148140 0.7313924434
1155173 0.7359550430
1188481 0.7598914553
1201155 0.7663406553
1206921... (2 Replies)
Dear all,
I have two files (each only contains 1 column) as attached. I want to combined the two files and only show the common records in both files. But when I use join command only the last row was combined. Anyone know what is the problem? I don't know how to write the correct code to only... (2 Replies)
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)
I have a weird issue going on with the join command...
I have two files I am trying to join...here is a line from each file with the important parts marked in red:
file1:
/groupspace/ccops/cmis/bauwkrcn/commsamp_20140315.txt,1
file2:... (3 Replies)
Discussion started by: dbiggied
3 Replies
LEARN ABOUT CENTOS
xmtablistcopy
XmTabListCopy(library call) XmTabListCopy(library call)
NAME
XmTabListCopy -- A convenience function that creates a new tab list from an existing list
SYNOPSIS
#include <Xm/Xm.h>
XmTabList XmTabListCopy(
XmTabList tablist,
int offset,
Cardinal count);
DESCRIPTION
XmTabListCopy creates a new tab list consisting of a copy of a portion of the contents of the tablist argument. This function starts copy-
ing at the specified offset value of the tab list and copies count values.
tablist Specifies a tab list to be copied.
offset Specifies where to start copying. A value of 0 (zero) indicates begin at the beginning, a value of 1 indicates to skip the first
tab, and so on. A negative indicates to begin counting backwards from the end. A value of -1 indicates to start copying from the
last tab.
count Specifies the number of tabs to copy. A value of 0 (zero) indicates to copy all elements from the starting point to the end
(beginning if offset is negative) of the tab list.
RETURN
If tablist is NULL, this function returns NULL. Otherwise, this function returns a newly allocated XmTabList. If the function does allo-
cate an XmTabList, then the application is responsible for managing the allocated space. The application can recover the allocated space
by calling XmTabListFree.
RELATED XmTabList(3) and XmTabListFree(3).
XmTabListCopy(library call)