02-05-2013
Joining 2 Files
HTML Code:
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
.....
HTML Code:
File "B" (column names: TYPE DEVICE NUMBER SIZE)
TYPE DEVICE NUMBER SIZE
1750500 hdisk2 100A 16384
1750500 hdisk3 1010 73728
1750500 hdisk5 1015 36864
1750500 hdisk4 1014 36864
I have two files above. On both files, "Number" (on A) and "NUMBER " (on B) are the join connector for these 2 file.
The output I want after the join is:
HTML Code:
Nickname Number GB TYPE DEVICE NUMBER SIZE REMARK
PROD_DB0034 100A 16 1750500 hdisk2 100A 16384
ASMIL1B_DATA_003 100B 16 -- -- -- -- (no match)
-- -- -- -- 1750500 hdisk3 1010 73728 (no match)
PSPROD_0000 1014 36 1750500 hdisk4 1014 36864
-- -- -- -- 1750500 hdisk5 1015 36864 (no match)
PSPROD_0001 100D 223 -- -- -- -- (no match)
Please advise.
Last edited by jim mcnamara; 02-05-2013 at 08:37 PM..
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. Shell Programming and Scripting
Hi guys,
I have three files which needs to be joined to a single file.
File 1:
Col a, Col b, Col c
File 2:
Col 1a, Col 1b
File 3:
Col 2a, Col 2b
Output:
Col 1a, Col 2a, Col a, Col b, Col c.
All the files are comma delimited. I need to join Col b with Col 1b and need to... (17 Replies)
Discussion started by: mac4rfree
17 Replies
7. 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
8. 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
9. 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
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
net::google::code
Net::Google::Code(3pm) User Contributed Perl Documentation Net::Google::Code(3pm)
NAME
Net::Google::Code - a simple client library for google code
SYNOPSIS
use Net::Google::Code;
my $project = Net::Google::Code->new( project => 'net-google-code' );
$project->load; # load its metadata, e.g. summary, owners, members, etc.
print join(', ', @{ $project->owners } );
# return a Net::Google::Code::Issue object, of which the id is 30
$project->issue( id => 30 );
# return a Net::Google::Code::Download object, of which the file name is
# 'FooBar-0.01.tar.gz'
$project->download( name => 'FooBar-0.01.tar.gz' );
# return a Net::Google::Code::Wiki object, of which the page name is 'Test'
$project->wiki( name => 'Test' );
# loads all the downloads
$project->load_downloads;
my $downloads = $project->downloads;
# loads all the wikis
$project->load_wikis;
my $wikis = $project->wikis;
DESCRIPTION
Net::Google::Code is a simple client library for projects hosted in Google Code.
Since 0.15, Net::Google::Code offers google's official issues api support. Besides the new "Net::Google::Code::Issue::list",
"Net::Google::Code::Issue::Comment::list" and <Net::Googlel::Code::Issue::load_comments> methods, which use the api from start, you can set
$Net::Google::Code::Issue::USE_HYBRID to true to load, create and update issue with the api too.
But the official api is not function complete yet( e.g. no attachment support, can't merge, etc. ), Net::Google::Code will back to the
scraping way to accomplish those stuff.
ATTRIBUTES
project
the project name
email, password
user's email and password, used to authenticate
base_url
the project homepage
base_svn_url
the project svn url (without trunk)
base_feeds_url
the project feeds url
summary
description
labels
owners
members
INTERFACE
load
load project's home page, and parse its metadata
parse
acturally do the parse job, for load();
load_downloads
load all the downloads, and store them as an arrayref in $self->downloads
load_wikis
load all the wikis, and store them as an arrayref in $self->wikis
issue
return a new Net::Google::Code::Issue object, arguments will be passed to Net::Google::Code::Issue's new method.
download
return a new Net::Google::Code::Download object, arguments will be passed to Net::Google::Code::Download's new method.
wiki
return a new Net::Google::Code::Wiki object, arguments will be passed to Net::Google::Code::Wiki's new method.
DEPENDENCIES
Any::Moose, HTML::TreeBuilder, WWW::Mechanize, Params::Validate XML::FeedPP, DateTime, JSON, URI::Escape, MIME::Types, File::MMagic
INCOMPATIBILITIES
None reported.
BUGS AND LIMITATIONS
No bugs have been reported.
This project is very very young, and api is not stable yet, so don't use this in production, at least for now.
AUTHOR
sunnavy "<sunnavy@bestpractical.com>"
Fayland Lam "<fayland@gmail.com>"
LICENCE AND COPYRIGHT
Copyright 2008-2010 Best Practical Solutions.
This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
perl v5.10.1 2010-04-26 Net::Google::Code(3pm)