Go Back   The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting
picking file from a particular URL and the processing picking file from a particular URL and the processing
Search Forums:

Forums Register Forum RulesLinux and Unix LinksMan PagesAlbums FAQ Users Calendar Search Today's Posts Mark Forums Read


Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts and shell scripting languages here.

Closed Thread    
 
Thread Tools Search this Thread Display Modes
    #1  
Old 09-03-2010
Registered User
  

Join Date: Apr 2009
Location: bangalore
Posts: 38
Thanks: 0
Thanked 0 Times in 0 Posts
Unhappy picking file from a particular URL and the processing

Code:
body { margin: 0 0 0 0; padding:0 0 0 0 }td,div { font-family:Courier New;font-size:10pt;vertical-align:top }body { margin: 0 0 0 0; padding:0 0 0 0 }.transcript { background-color:#d2d2d2; }.messageBlock { margin-left:4px; margin-bottom:3px }.message { margin-left:100px; word-wrap:break-word; white-space:-moz-pre-wrap; _white-space:pre; }.messageCont { margin-left:100px; word-wrap:break-word; white-space:-moz-pre-wrap; _white-space:pre;}.other { color:#39577a;vertical-align:top;font-weight:bold;font-style:normal;float:left; width:95px; }.myself { color:#da8103;font-style:normal;font-weight:bold;font-style:normal;float:left; width:95px; }.otherCont { font-size:8px;text-align:right; color:#39577a;font-family:Arial,Lucida Grande;font-style:normal;vertical-align:top;font-weight:bold;float:left; width:95px; }.myselfCont { font-size:8px;text-align:right; color:#da8103;font-family:Arial,Lucida Grande;font-style:normal;vertical-align:top;font-weight:bold;float:left; width:95px; }.system { margin-left:4px; word-wrap:break-word;color:#da8103;font-style:normal;font-weight:normal; white-space:-moz-pre-wrap; _white-space:pre; }.showTimestamp { margin-right:3px; float:right; color:#999999;font-style:normal;font-weight:normal; }.other1 { color:#ac2000;vertical-align:top;font-weight:bold;font-style:normal;float:left; width:95px; }.otherCont1 { font-size:8px;text-align:right; color:#ac2000;font-family:Arial,Lucida Grande;font-style:normal;vertical-align:top;font-weight:bold;float:left; width:95px; }.other2 { color:#3c9fa8;vertical-align:top;font-weight:bold;font-style:normal;float:left; width:95px; }.otherCont2 { font-size:8px;text-align:right; color:#3c9fa8;font-family:Arial,Lucida Grande;font-style:normal;vertical-align:top;font-weight:bold;float:left; width:95px; }.other3 { color:#e25614;vertical-align:top;font-weight:bold;font-style:normal;float:left; width:95px; }.otherCont3 { font-size:8px;text-align:right; color:#e25614;font-family:Arial,Lucida Grande;font-style:normal;vertical-align:top;font-weight:bold;float:left; width:95px; }.other4 { color:#0b6ac8;vertical-align:top;font-weight:bold;font-style:normal;float:left; width:95px; }.otherCont4 { font-size:8px;text-align:right; color:#0b6ac8;font-family:Arial,Lucida Grande;font-style:normal;vertical-align:top;font-weight:bold;float:left; width:95px; }.other5 { color:#b23290;vertical-align:top;font-weight:bold;font-style:normal;float:left; width:95px; }.otherCont5 { font-size:8px;text-align:right; color:#b23290;font-family:Arial,Lucida Grande;font-style:normal;vertical-align:top;font-weight:bold;float:left; width:95px; }.other6 { color:#02e7c7;vertical-align:top;font-weight:bold;font-style:normal;float:left; width:95px; }.otherCont6 { font-size:8px;text-align:right; color:#02e7c7;font-family:Arial,Lucida Grande;font-style:normal;vertical-align:top;font-weight:bold;float:left; width:95px; }.other7 { color:#5b3284;vertical-align:top;font-weight:bold;font-style:normal;float:left; width:95px; }.otherCont7 { font-size:8px;text-align:right; color:#5b3284;font-family:Arial,Lucida Grande;font-style:normal;vertical-align:top;font-weight:bold;float:left; width:95px; }.tsDisplay { display:block } Hi,

Is it possible to complete the following steps in a shell script.

1) Picking up a file (File Name format: CHANGELOG_GBT_MONTH_yyyy.xls) from a particular URL where "MONTH" = Current Month and "yyyy" = current year.

2) Extract the 4 different columns(columns A,B,F,I of the excel sheet mentioned above) from the 4th sheet tab and Load them into a Custom Table.

3)Some Validations are to be performed on the table after which the records are to be exported in XX_XXXXX_XXXXX_XX_XXXXXX.csv file
CSV file will be of UTF 16,Tab delimited format having 2 columns.

I'm new to Shell Scripts.


Moderator's Comments:
Having 38 posts you should be familiar with the use of code tags!
Sponsored Links
Closed Thread

« curl ftp script | how to write a shellscript to send a mail alert to the website user based on license expiration time »
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
Using awk : picking specified columns kkarthik_kaja UNIX for Advanced & Expert Users 1 07-21-2010 05:27 AM
Picking high and low variables in a bash script - possible? graysky Shell Programming and Scripting 5 11-25-2009 09:48 AM
parsing data file picking out certain fields timj123 Shell Programming and Scripting 8 03-05-2008 05:57 PM
Picking the file based on Date..Requirement sureshg_sampat Shell Programming and Scripting 5 06-06-2007 05:51 AM
Picking out text from one file and writing it to another. scottf33 UNIX for Dummies Questions & Answers 5 05-20-2005 09:43 AM



All times are GMT -4. The time now is 04:05 AM.

The UNIX and Linux Forums - Learn UNIX and UNIX Commands RSS Feeds - Contact Us - The UNIX and Linux Forums - Learn UNIX and UNIX Commands - Archive - Botnik - Top
Language Translations Powered by Google SEO by vBSEO
The UNIX and Linux Forums Content Copyright ©1993-2011. All Rights Reserved.
Forum Operations by The UNIX and Linux Forums
Powered by: vBulletin, Copyright ©2000 - 2006, Jelsoft Enterprises Limited.