Paste two file side by side together based on specific pattern match problem
Input file_1:
Input file_2:
Desired output file:
File_1 consider the back-bone of my desire output file. The data at File_1 must be presented at the desired output file no matter is empty line or data that don't match with file 2.
Besides that, the output data sequence must follow exactly like file_1. Some data at file 1, might apprear more than once as well. My purpose is to paste those file_2 data that got match with file_1 data to the output file.
Thanks for any suggestion.
Hi,
I have to sql queries like
select sno,sname from temptable;
select deptno,dname from depttable;
In excel i want to specify the column number to which my output should be displayed.
please help me in this...
thanks in advance... (6 Replies)
Hi Everyone,
I need a shell/perl script to bring selected columns from all the files located in a directory and place them in a new file side by side.
File1:
a b c d
2 3 4 5
f g h i
..........
File2:
I II III IV
w x y z
..............
and so on many files are there...... (8 Replies)
I have 2 text files, both have one simple, single column. The 2 files might be the same length, or might not, and if not, it's unknown which one would be longer.
For this example, file1 is longer:
---file1
Joe
Bob
Mary
Sally
Fred
Elmer
David
---file2
Tomato
House
Car... (3 Replies)
I have installed WAMPSERVER 2.0 on my windows vista x64 system but still am having issues with getting the webserver to be seen outside my local network. It is working fine within my local network.
Been through several setup tutorials so far, no dice still.
For testing purposes I have... (1 Reply)
Hi All,
I have a file abc.xls which contains data
applciation usage
merlin 24000
hermes 48000
and my script generates an output to a file def.xls
applciation usage
merlin 23000
hermes 50000
Daily i want to schedule this script to run and I need the second column to be appended to the... (2 Replies)
Hi I'm trying to compare 3 or more files based on similar values and outputting them into 3 columns.
For example:
file1
ABC
DEF
GHI
file2
DEF
DER
file3
ABC
DER
The output should come out like this
file1 file2 file3
ABC ABC (4 Replies)
I have about 100s of files of type text in a known directory. I want to merge all files side by side. Number of lines in all the files will remain same.
For example file1 contains
cat
dog
File 2 contains
rat
mat
Output file should be
cat rat
dog mat
Using awk I was able to... (5 Replies)
Hi Team,
I have input like
Input file.txt
Contents:
Total: 939720704 bytes
Total: 521142272 bytes
Total: 262144 bytes
Total: 786432 bytes
Total: 9043968 bytes
Total: 9371648 bytes
I need out put like the content of file should be side by side.that is 1st line beside... (3 Replies)
Hi,
Thank you for your help in advance :D.
I have thousands of files like...
file01
file02
file03
.
.
.
file6324
I would like to paste every other file side by side so it looks like
file01 file02
file03 file04
...e.t.c
file6323 file6324 (3 Replies)
Could I run 2 python scripts at the same time side by side output on the same line in this same format but with scripts?
from itertools import izip_longest
with open("file1") as textfile1, open("file2") as textfile2:
for x, y in izip_longest(textfile1, textfile2, fillvalue=""):
x =... (4 Replies)
Discussion started by: bigvito19
4 Replies
LEARN ABOUT DEBIAN
finance::quotehist::yahoo::australia
Finance::QuoteHist::Yahoo::Australia(3pm) User Contributed Perl Documentation Finance::QuoteHist::Yahoo::Australia(3pm)NAME
Finance::QuoteHist::Yahoo::Australia - Site-specific subclass for retrieving historical stock quotes.
SYNOPSIS
use Finance::QuoteHist::Yahoo::Australia;
$q = Finance::QuoteHist::Yahoo::Australia->new(
symbols => [qw(BHP.AX)],
start_date => '01/01/1999',
end_date => 'today',
);
# Values
foreach $row ($q->quotes()) {
($symbol, $date, $open, $high, $low, $close, $volume) = @$row;
...
}
# Splits
foreach $row ($q->splits()) {
($symbol, $date, $post, $pre) = @$row;
}
# Dividends
foreach $row ($q->dividends()) {
($symbol, $date, $dividend) = @$row;
}
DESCRIPTION
Finance::QuoteHist::Yahoo::Australia is a subclass of Finance::QuoteHist::Yahoo, specifically tailored to read historical quotes,
dividends, and splits from the Yahoo Australia web site (http://au.finance.yahoo.com/).
Please see Finance::QuoteHist::Yahoo(3) for more details on usage and available methods. If you just want to get historical quotes and are
not interested in the details of how it is done, check out Finance::QuoteHist(3).
METHODS
The basic user interface consists of three methods, as seen in the example above. Those methods are:
quotes()
Returns a list of rows (or a reference to an array containing those rows, if in scalar context). Each row contains the Symbol, Date,
Open, High, Low, Close, and Volume for that date.
dividends()
Returns a list of rows (or a reference to an array containing those rows, if in scalar context). Each row contains the Symbol, Date,
and amount of the Dividend, in that order.
splits()
Returns a list of rows (or a reference to an array containing those rows, if in scalar context). Each row contains the Symbol, Date,
Post split shares, and Pre split shares, in that order.
REQUIRES
Finance::QuoteHist::Yahoo
DISCLAIMER
The data returned from these modules is in no way guaranteed, nor are the developers responsible in any way for how this data (or lack
thereof) is used. The interface is based on URLs and page layouts that might change at any time. Even though these modules are designed to
be adaptive under these circumstances, they will at some point probably be unable to retrieve data unless fixed or provided with new
parameters. Furthermore, the data from these web sites is usually not even guaranteed by the web sites themselves, and oftentimes is
acquired elsewhere.
If you would like to know more, check out the terms of service from Yahoo!, which can be found here:
http://au.docs.yahoo.com/info/terms/
If you still have concerns, then use another site-specific historical quote instance, or none at all.
Above all, play nice.
AUTHOR
Matthew P. Sisk, <sisk@mojotoad.com>
COPYRIGHT
Copyright (c) 2010 Matthew P. Sisk. All rights reserved. All wrongs revenged. This program is free software; you can redistribute it and/or
modify it under the same terms as Perl itself.
SEE ALSO Finance::QuoteHist::Yahoo(3), Finance::QuoteHist::Generic(3), Finance::QuoteHist(3), perl(1).
perl v5.12.4 2010-06-07 Finance::QuoteHist::Yahoo::Australia(3pm)