08-11-2011
Quote:
First file
Name TransactionID StoreID CustomerID RegTransr TransactionCode
StoreCENTER 620499 1238 12380005080811100000 1619 1501
StoreCENTER 620500 1238 12380005080811100000 1620 1501
StoreCENTER 634956 557 3243 1
StoreCENTER 620501 1238 8871 2
StoreCENTER 634957 557 3244 1
StoreCENTER 1030086 625 8979 1
StoreCENTER 620507 1238 4200 1
StoreCENTER 1030087 625 8980 1
StoreCENTER 620508 1238 8874 2
StoreCENTER 620511 1238 4201 1
StoreCENTER 620512 1238 12380005080811100000 1625 1501
Second File
TransactionID StoreID SequenceID
620499 1238 1
620500 1238 1
620512 1238 1
620528 1238 1
620535 1238 1
620543 1238 1
620545 1238 1
Output File
Name TransactionID StoreID CustomerID RegTransr TransactionCode SequenceID
StoreCENTER 620499 1238 12380005080811100000 1619 1501 1
StoreCENTER 620500 1238 12380005080811100000 1620 1501 1
StoreCENTER 634956 557 3243 1
StoreCENTER 620501 1238 8871 2
StoreCENTER 634957 557 3244 1
StoreCENTER 1030086 625 8979 1
StoreCENTER 620507 1238 4200 1
StoreCENTER 1030087 625 8980 1
StoreCENTER 620508 1238 8874 2
StoreCENTER 620511 1238 4201 1
StoreCENTER 620512 1238 12380005080811100000 1625 1501 1
Files are joined by TransactionCode(Second Column after StoreCENTER) and StoreID (next Column) . The Last column from the output is coming from Second file
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi,
I have two files that I need to find difference between. Do I use diff or join? If join, how do I use it?
thanks,
webtekie (1 Reply)
Discussion started by: webtekie
1 Replies
2. UNIX for Dummies Questions & Answers
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)
Discussion started by: Manu
2 Replies
3. Shell Programming and Scripting
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)
Discussion started by: rjlohman
3 Replies
4. Shell Programming and Scripting
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)
Discussion started by: kylle345
1 Replies
5. Shell Programming and Scripting
i have three files
file a has contents
123
234
238
file b has contents
189
567
567
and file c has contents
qwe
ert
ery (1 Reply)
Discussion started by: tomjones
1 Replies
6. UNIX for Dummies Questions & Answers
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)
Discussion started by: pandeesh
10 Replies
7. Shell Programming and Scripting
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)
Discussion started by: RayanS
1 Replies
8. Shell Programming and Scripting
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)
Discussion started by: rrdavis
8 Replies
9. Shell Programming and Scripting
File "A" (column names: Nickname Number GB)
Nickname Number GB
PROD_DB0034 100A 16
ASMIL1B_DATA_003 100B 16
PSPROD_0000 1014 36
PSPROD_0001 100D 223
.....
File "B" (column names: TYPE DEVICE NUMBER SIZE)
TYPE DEVICE NUMBER SIZE
1750500 hdisk2 100A 16384
1750500 hdisk3 ... (4 Replies)
Discussion started by: Daniel Gate
4 Replies
10. Shell Programming and Scripting
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)