ohh.. thanks for that.. now the command is running. But i am getting all the records in second file whereas i need only the matched records. Let me explain one more time.
First file:
4th column in first file has to do a lookup with 1st column in second file and has to be bring me the output with the additinal columns from the second file.
Hi,
Could anyone help me ?
I'm trying to join two files, but no common field are on them. So I think on generate \000\ sequence to add for each line on both files, so then will be able to join these files.
Any idea?
Thanks in advance, (2 Replies)
Greetings, all. I've got a project that requires I join two data files together, then do some processing and output. Everything must be done in a shell script, using standard unix tools. The files look like the following:
File_1
Layout:
Acct#,Subacct#,Descrip
Sample:
... (3 Replies)
Hi,
Whats the unix function to join multiple files? is it cat?
so I have multiple files in the same format and I want to join then by row
eg.
FILE1
1 3
1 3
1 3
1 3
FILE2
2 4
2 4
2 4 (1 Reply)
I have two comma separated files.
I want to join those filesa nd put the result in separate file.
smaple data are:
file1:
A1,1,100
A2,1,200
B1,2,100
B2,2,200
file2
1,50
1,25
1,25
1,100
1,100
2,50
2,50 (10 Replies)
Hi experts,
I'm quite newbie here!!
I have two seperate files. Contents of file like below
File 1:
6213019212001 8063737
File:2
15703784
I want to join these two files into one where content will be
File 3:
6213019212001 8063737 15703784
Regards,
Ray Seilden (1 Reply)
Hi,
I have about 20 tab delimited text files that have non sequential numbering such as:
UCD2.summary.txt
UCD45.summary.txt
UCD56.summery.txt
The first column of each file has the same number of lines and content. The next 2 column have data points:
i.e UCD2.summary.txt:
a 8.9 ... (8 Replies)
I have two files with the below contents :
sampleoutput3.txt
20150202;hostname1
20150223;hostname2
20150716;hostname3
sampleoutput1.txt
hostname;packages_out_of_date;errata_out_of_date;
hostname1;11;0;
hostnamea;12;0;
hostnameb;11;0;
hostnamec;95;38;
hostnamed;440;358;... (2 Replies)
Discussion started by: rahul2662
2 Replies
LEARN ABOUT DEBIAN
prima::detailedlist
Prima::DetailedList(3) User Contributed Perl Documentation Prima::DetailedList(3)NAME
Prima::DetailedList - a multi-column list viewer with controlling header widget.
SYNOPSIS
use Prima::DetailedList;
my $l = $w-> insert( 'Prima::DetailedList',
columns => 2,
headers => [ 'Column 1', 'Column 2' ],
items => [
['Row 1, Col 1', 'Row 1, Col 2'],
['Row 2, Col 1', 'Row 2, Col 2']
],
);
$l-> sort(1);
DESCRIPTION
Prima::DetailedList is a descendant of Prima::ListViewer, and as such provides a certain level of abstraction. It overloads format of items
in order to support multi-column ( 2D ) cell span. It also inserts Prima::Header widget on top of the list, so the user can interactively
move, resize and sort the content of the list. The sorting mechanism is realized inside the package; it is activated by the mouse click on
a header tab.
Since the class inherits Prima::ListViewer, some functionality, like 'item search by key', or "get_item_text" method can not operate on 2D
lists. Therefore, mainColumn property is introduced, that selects the column representing all the data.
API
Events
Sort COLUMN, DIRECTION
Called inside sort method, to facilitate custom algorithms of sorting. If the callback procedure is willing to sort by COLUMN index,
then it must call "clear_event", to signal the event flow stop. The DIRECTION is a boolean flag, specifying whether the sorting must be
performed is ascending ( 1 ) or descending ( 0 ) order.
The callback procedure must operate on the internal storage of "{items}", which is an array of arrays of scalars.
The default action is the literal sorting algorithm, where precedence is arbitrated by "cmp" operator ( see "Equality Operators" in
perlop ) .
Properties
columns INTEGER
Governs the number of columns in items. If set-called, and the new number is different from the old number, both items and headers are
restructured.
Default value: 0
headerClass
Assigns a header class.
Create-only property.
Default value: "Prima::Header"
headerProfile HASH
Assigns hash of properties, passed to the header widget during the creation.
Create-only property.
headerDelegations ARRAY
Assigns a header widget list of delegated notifications.
Create-only property.
headers ARRAY
Array of strings, passed to the header widget as column titles.
items ARRAY
Array of arrays of scalars, of arbitrary kind. The default behavior, however, assumes that the scalars are strings. The data direction
is from left to right and from top to bottom.
mainColumn INTEGER
Selects the column, responsible for representation of all the data. As the user clicks the header tab, "mainColumn" is automatically
changed to the corresponding column.
Default value: 0
Methods
sort [ COLUMN ]
Sorts items by the COLUMN index in ascending order. If COLUMN is not specified, sorts by the last specified column, or by #0 if it is
the first "sort" invocation.
If COLUMN was specified, and the last specified column equals to COLUMN, the sort direction is reversed.
The method does not perform sorting itself, but invokes Sort notification, so the sorting algorithms can be overloaded, or be applied
differently to the columns.
AUTHOR
Dmitry Karasik, <dmitry@karasik.eu.org>.
SEE ALSO
Prima, Prima::Lists, Prima::Header, examples/sheet.pl
perl v5.14.2 2009-02-24 Prima::DetailedList(3)