Search Results

That was one of my concerns RudiC. I am unable to decide what the standard header should be as the header of the file keeps changing every week. This check should be part of my shell script.

Appreciate your response RudiC. Your code prints the columns with their columns numbers as shown below.
1 - - Column1
2 - - Column2
3 - - Column3
4 - - Column4
5 - - Column5
6 - - Column6...

I have a .CSV file (frequency - weekly) whose header contains the year-week value in two of the columns which keeps changing every week. For an instance please see below....

Thank you. I will have to do more digging I guess to implement this right... Or, I will add one more code to check the number of files downloaded in the destination after the FTP script gets...

Okay, I checked what FTP command from the script gives the output. It is as below
Local directory now /dir1/dir2/dir3
No files found.
0
Successful transfer of the files...0 2014-06-24-12.19.19...

I did echo $rcand it was returning '0'. I believe it is returning this after successfully completing the closeand byecommands. But, how can it return an error code or exit code as '1' in case there...

I have a script which connects to a remote server via FTP and gets some file from there.

#!/bin/bash
/usr/bin/ftp -n remote.hostname.com <<EOF
quote USER user123
quote PASS password123
lcd...

@Don, @RudiC - Thank you for the help. I will keep these points in mind while developing the script.

@Don, I tried the script in the following way, but I am stuck in the middle part where I need to check the conditions for each request flag separately. Could you please help me out.

while [ 2 -ge...

Our ETL tool is installed on Linux and currently many of the jobs such as (a)formatting the files received by us (as per our requirement) from different sources/users, (b) placing the indicator/flag...

I have to check a directory on Linux (via shell Script which I am trying to build) for about 20 different source files with file patterns and if the files are made available in the directory, I...

@Don Cragun: Great explanation, no one could have done it better than this... Thank you so much.

@rk4k: please share your thoughts. Do you mean this approach does not work in all the cases?...

@in2nix4life: The code works great, however, I will really appreciate if you could please help me understand the for condition? like, why was the i assigned 2 as the initial value and also, the...

Okay, I would like to delete all the commas in a .CSV file (TEST.CSV) or at least substitute them with empty space, that are enclosed in double quote.

Please see the sample file as below:
column...

I am trying to count the number of records from different files using grep, and then place the result in a separate variable for each file, so at the end of my shell script, I can sum all the...

All - I am sorry for the confusion. i have edited the sample file. Please take a look now...

@akash: I am not getting the output that I was expecting. Using your code, I got the output as below:

column 1,column 2,column 3,column 4,column 5,column 6,column 7,column 8,column 9,column 10...

Sample would be like this:
column 1,column 2,column 3,column 4,column 5,column 6,column 7,column 8,column 9,column 10
12310,42324564756,"a simple string with a , comma","string with or, without...

Okay, got it...
I do have dos2unix and will use this.
thanks...

Changing the transfer mode to Binary before doing the file transfer using winscp worked for the .gz file. Do I have to keep changing the transfer mode every time I transfer different kinds of files?...

@Corona688: I have checked under the FTP client's (WinSCP) settings and the transfer mode is set to Text(Plain text, html, scripts,....) I do not think it is uploading the files in ASCII mode. Also...

If the file were a regular .gzfile, then any one of your solutions might have worked I guess... this file might be corrupted like you said and since the file uncompresses easily using winzip, also I...

I FTPd using Winscp to transfer the file that I downloaded from the merchant's web portal into Linux location. winzip works and extracts the file very easily, but I am having trouble using unzip...

Actually, I downloaded the report from a merchant's website and it usually downloads in the same format. Earlier, we used to extract the file on Windows, then place it on our FTP server location....