01-12-2007
Automatic download of csv file using a shell script
I want to automatically download a CSV file daily which can be found here:
http://www.londonstockexchange.com/e...nts/search.htm
and the link is named "Click to download covered warrants (100Kb)" onthe right hand side.
What commands can I use to invoke clicking on this link and initiating the download? And also what commands can I use to save the file locally?
Thanks in advance
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi all,
I have some script that creates a temp csv file. What I need to do is do some search and replace and modify the file from my shell script. I know the commands to open the file and then apply the reg ex but wasnt sure how I could do this from a script and modify the file?
Any help... (2 Replies)
Discussion started by: not4google
2 Replies
2. Shell Programming and Scripting
I have a CSV file which contains number series as one of the fields. Some of the records of the field look like :
079661/3
I have to convert the above series as
079661
079662
079663
and store it as 3 different records.
Looking for help on how to achieve this. Am a newbie at Shell... (10 Replies)
Discussion started by: mihirk
10 Replies
3. UNIX for Advanced & Expert Users
i have a report.csv file from oracle datavase
In that file data is like this with report heading and date
SALES DAILY REPORT
DATE: 06-26-2007
REPORT NAME: SALES DATA
AA.BB.CCCC.DDDD,BBBBB,06-26-2007,0,BEGIN,END
ZZ.VV.DDDD.XXXXXXX,MMMMMM,06-25-2007,18,BEGIN,END... (3 Replies)
Discussion started by: raosurya
3 Replies
4. Shell Programming and Scripting
I have a file in multiple directory which has some records in the following format
File: a/latest.txt , b/latest.txt, c/latest.txt ->
Name=Jhon
Age=27
Gender=M
Street=LA Road
Occupation=Service
I want to generate a csv file from the above file as follows
File: output.csv ->
... (9 Replies)
Discussion started by: rjk2504
9 Replies
5. UNIX for Dummies Questions & Answers
Hello !
I am very aware that this is not the first time this question is asked here, because I have already read a lot of previous answers, but none of them worked, so...
As said in the title, I want to read a csv file with a bash script.
Here is a sample of the file:
... (4 Replies)
Discussion started by: Grhyll
4 Replies
6. UNIX for Dummies Questions & Answers
Hi
I have a mail attachment coming from a mail id and evreytime with the same name in .xls format.I have to download the .xls file into a location and convert it itno .csv format and copy the .csv file to another location. (1 Reply)
Discussion started by: bikky6
1 Replies
7. Shell Programming and Scripting
Hello this is my first post in this forum , I dont want to be unhappy..
I am writing one script but facing difficulty to find the latest file with some new pattern
My requirement is
1. The file is coming like "ABCD-23220140303" at FTP server once in a week.
2. script will run on daily... (3 Replies)
Discussion started by: ajju
3 Replies
8. Shell Programming and Scripting
Hi All,
I am trying to create a CSV file within a shell script test.ksh and the code snippet is something like below:
#!/usr/bin/ksh
# Set required variables.
. $HOME/.prof
# Output file path
Group1=/tmp/G1.csv
Group2=/tmp/G2.csv
Group3=/tmp/G3.csv
$ORACLE_HOME/bin/sqlplus -s... (2 Replies)
Discussion started by: swasid
2 Replies
9. Shell Programming and Scripting
I am attempting to download a url in csv format. When I download this url in a browser excel opens up and automatically populates with comma separated values.
When I try to use curl or wget I get nothing or garbage.
This on the command line just hangs
wget -b... (2 Replies)
Discussion started by: bash_in_my_head
2 Replies
10. Shell Programming and Scripting
Hello Unix Shell Script Experts,
I have a script that would mask the columns in .csv file or .txt file.
First the script will untar the .zip files from Archive folder and processes into work folder and finally pushes the masked .csv files into Feed folder.
Two parameters are passed
... (5 Replies)
Discussion started by: Mahesh G
5 Replies
download(1) User Commands download(1)
NAME
download - host resident PostScript font downloader
SYNOPSIS
download [-f] [-p printer] [-m name] [-H directory] [file...]
/usr/lib/lp/postscript/download
DESCRIPTION
download prepends host resident fonts to files and writes the results on the standard output. If no files are specified, or if - is one of
the input files, the standard input is read. download assumes the input files make up a single PostScript job and that requested fonts can
be included at the start of each input file.
Requested fonts are named in a comment (marked with %%DocumentFonts:) in the input files. Available fonts are the ones listed in the map
table selected using the -m option.
The map table consists of fontname-file pairs. The fontname is the full name of the PostScript font, exactly as it would appear in a %%Doc-
umentFonts: comment. The file is the pathname of the host resident font. A file that begins with a / is used as is. Otherwise the pathname
is relative to the host font directory. Comments are introduced by % (as in PostScript) and extend to the end of the line.
The only candidates for downloading are fonts listed in the map table that point download to readable files. A font is downloaded once,
at most. Requests for unlisted fonts or inaccessible files are ignored. All requests are ignored if the map table can not be read.
OPTIONS
-f Force a complete scan of each input file. In the absence of an explicit comment pointing download to the end of the file,
the default scan stops immediately after the PostScript header comments.
-p printer Check the list of printer-resident fonts in /etc/lp/printers/printer/residentfonts before downloading.
-m name Use name as the font map table. A name that begins with / is the full pathname of the map table and is used as is. Other-
wise name is appended to the pathname of the host font directory.
-H directory Use dir as the host font directory. The default is /usr/lib/lp/postscript.
EXAMPLES
Example 1: Examples of the download command.
The following map table could be used to control the downloading of the Bookman font family:
%
% The first string is the full PostScript font name. The second string
% is the file name - relative to the host font directory unless it begins
% with a /.
%
Bookman-Light bookman/light
Bookman-LightItalic bookman/lightitalic
Bookman-Demi bookman/demi
Bookman-DemiItalic bookman/demiitalic
Using the file myprinter/map (in the default host font directory) as the map table, you could download fonts by issuing the following
command:
example% download -m myprinter/map file
EXIT STATUS
The following exit values are returned:
0 Successful completion.
non-zero An error occurred.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWpsf |
+-----------------------------+-----------------------------+
SEE ALSO
dpost(1), postdaisy(1), postdmd(1), postio(1), postmd(1), postprint(1), posttek(1), attributes(5)
NOTES
The download program should be part of a more general program.
download does not look for %%PageFonts: comments and there is no way to force multiple downloads of a particular font.
Using full pathnames in either map tables or the names of map tables is not recommended.
SunOS 5.10 9 Sep 1996 download(1)