Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

File search variables

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting File search variables
# 8  
Old 12-13-2007
Code:
#!/bin/ksh

ftp -nv <<EOF
open remoteServer
user userName userPassword
cd desiredDirectory
mls Daily_Generated_File_* myLocalListingFile
EOF
# once you get the 'myLocalListingFile' on the LOCAL server, go through files listed in the 
# file and decide which one is the latest.
# Once decided, ftp to the remote server and get the desired file
ftp -nv <<EOF
open remoteServer
user userName userPassword
cd desiredDirectory
get desiredLatestFile
EOF

# 9  
Old 12-13-2007
Quote:
Originally Posted by vgersh99
Code:
#!/bin/ksh

ftp -nv <<EOF
open remoteServer
user userName userPassword
cd desiredDirectory
mls Daily_Generated_File_* myLocalListingFile
EOF
# once you get the 'myLocalListingFile' on the LOCAL server, go through files listed in the 
# file and decide which one is the latest.
# Once decided, ftp to the remote server and get the desired file
ftp -nv <<EOF
open remoteServer
user userName userPassword
cd desiredDirectory
get desiredLatestFile
EOF

If I knew where to find you, I would and kiss ya! Smilie

I got the file listing, THANKS! But now, how to I go through the list, select the latest file, the have FTP go back and grab that one file? Smilie
# 10  
Old 12-13-2007
nawk -F_ -f bbb.awk myLocalListingFile | sort -k1n | cut -f2- | tail -1

bbb.awk:
Code:
{
  d=substr($NF, 1, index($NF, ".")-1)
  split(d, dA, "-")
  print dA[3] dA[1] dA[2] "\t" $0
}

where 'myLocalListingFile' looks something similar to:
Code:
Daily_Generated_File_11-14-07.txt
Daily_Generated_File_11-17-07.txt
Daily_Generated_File_11-24-07.txt
Daily_Generated_File_11-13-07.txt

Last edited by vgersh99; 12-13-2007 at 01:26 PM.. Reason: added '-F_'
# 11  
Old 12-13-2007
ok great!

We're almost there. Now, how to I get the FTP to get that file?

ftp -nv <<EOF
open remoteServer
user userName userPassword
cd desiredDirectory
get $(nawk -F_ -f bbb.awk Filelisting.txt | sort -k1n | cut -f2- | tail -1)
EOF

?
# 12  
Old 12-13-2007
sure.
Or you can put it all in ONE ftp session:
connecting
cd-ing
getting the listing
'munging' the listing file
getting the LATEST file
# 13  
Old 12-13-2007
Here's what I tried:

ftp -nv <<EOF
open ftpserver.com
user username password
mls Daily_Generated_File_* Filelisting.txt
get $(nawk -F_ -f bbb.awk Filelisting.txt | sort -k1n | cut -f2- | tail -1)
EOF


SWEET!!!!!!

You must be ROOT!
# 14  
Old 12-13-2007
one lil change:
Code:
ftp -nv <<EOF
open ftpserver.com
user username password
mls "Daily_Generated_File_*" Filelisting.txt
get $(nawk -F_ -f bbb.awk Filelisting.txt | sort -k1n | cut -f2- | tail -1)
EOF

you want the wild-card expansion to happen on the REMOTE machine - not in the current working directory on the LOCAL machine.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Read in search strings from text file, search for string in second text file and output to CSV

Hi guys, I have a text file named file1.txt that is formatted like this: 001 , ID , 20000 002 , Name , Brandon 003 , Phone_Number , 616-234-1999 004 , SSNumber , 234-23-234 005 , Model , Toyota 007 , Engine ,V8 008 , GPS , OFF and I have file2.txt formatted like this: ... (2 Replies)
Discussion started by: An0mander
2 Replies

2. Shell Programming and Scripting

Retrieving the relevant search from search file in the main file

I have two files: file 1: hello.com neo.com,japan.com,example.com news.net xyz.com, telecom.net, highlands.net, software.com example2.com earth.net, abc.gov.uk file 2: neo.com example.com abc.gov.uk file 2 are the search keys to search in file 1 if any of the search... (7 Replies)
Discussion started by: csim_mohan
7 Replies

3. Shell Programming and Scripting

Perl - use search keywords from array and search a file and print 3rd field when matched

Hi , I have been trying to write a perl script to do this job. But i am not able to achieve the desired result. Below is my code. my $current_value=12345; my @users=("bob","ben","tom","harry"); open DBLIST,"<","/var/tmp/DBinfo"; my @input = <DBLIST>; foreach (@users) { my... (11 Replies)
Discussion started by: chidori
11 Replies

4. Shell Programming and Scripting

awk search/replace specific field, using variables for regexp & subsitution then overwrite file

Hello, I'm trying the solve the following problem. I have a file which I intend to use as a csv called master.csv The columns are separated by commas. I want to change the text on a specific row in either column 3,4,5 or 6 from xxx to yyy depending upon if column 1 matches a specified pattern.... (3 Replies)
Discussion started by: cyphex
3 Replies

5. Shell Programming and Scripting

awk - ignore metacharacters, search shell variables

Can I use awk to search for a string, passed from the shell, that might include metacharacters? File1 entries: Bob Marley Jammin (Bonus Track).mp3 File2 entries: Bob Marley Jammin (Bonus Track).mp3 32000 /Music/Bob Marley/ Jammin (Bonus Track).mp3 So far, I have this; $ sed -e... (9 Replies)
Discussion started by: DSommers
9 Replies

6. UNIX for Advanced & Expert Users

use of variables in awk to search for pattern from a file

Hi, I need to extract all the content between two strings stored in two variables "startstring" and "endstring" startstring=hello enstring=world #notworking awk '/$startstring/, $NF ~ /$endstring/ ' file > file2 The above code is not working with variables. It works when actual string... (2 Replies)
Discussion started by: jeanjkj
2 Replies

7. Shell Programming and Scripting

Search between 2 variables

Hi Guys... can you tell me how to search between 2 variables ?... Im looking for a script that will move the data between varying words to separate files. I dont have my data on which I need to work right now... but it looks something like this.. start name1 data(a) data(b) stop name1 ... (6 Replies)
Discussion started by: R!C
6 Replies

8. HP-UX

Search environment variables for paths

Hi, I am using the HP machine at the moment and by default I have been setup with the kron shell i.e. my home profile is .kshrc I would like to access a program anywhere on the system so I have added a path and created an environment variable like this: export myvarpath=/a/abc/def/ghij... (3 Replies)
Discussion started by: cyberfrog
3 Replies

9. Shell Programming and Scripting

search and replace using awk with variables

Hi, I have been trying to use awk with variables that needs to search for a pattern and replace it with another pattern, the patterns are supplied in a variable. I have tried several different ways without success and hope that someone can help me. Here are the details echo $UPC 07007457809... (2 Replies)
Discussion started by: jerardfjay
2 Replies

10. Shell Programming and Scripting

Ksh script - Design ? - Search file and set variables

Hi - I'm trying to think of a clever way to write a shell script (trying to stay w/ ksh as that's what I know the best...) that will resolve the following problem: Problem - On a daily basis I have to email folks who are on-call to remind them. I was hoping to script this out so I could have... (9 Replies)
Discussion started by: littlefrog
9 Replies
Login or Register to Ask a Question