This works fine by shell commands.Is it possible to club the awk in the scp command and redirect the output to a file.I tried by piping but it is not giving any result.
Another way is to change to the required directory and put awk command.But cd is not working in shell script.
Please suggest a way to resolve this.
Moderator's Comments:
Please wrap all code, files, input & output.errors in CODE tags.
It makes it easier to read and preserves multiple spaces for indenting or fixed-width data.
Having got the files, would a loop using stat and it's various flags be suitable? You don't tell us you OS, so I'm hoping it is available to you by default. The risk with trying to read the output of something like ls -l is that group names may contain multiple spaces, but maybe none, so that would cause a mismatch on your field counts.
Looking at my manual page for stat, I would use the -c flag with parameters to get the values like this:-
Code:
$ stat -c '%y' /etc/profile
2017-03-21 21:56:32.000000000 +0000
You could build on this with a loop, e.g.:-
Code:
for filename in *
do
timestamp=$(stat -c %y $filename)
## Trim the timestamp as required or adjust it to your required format
array_val="${array_val},${timestamp} ${filename}"
done
array_val="${array_val#,}" # Trim off leading comma
array=("${array_val}")
Does that help? The timestamps from stat would be numeric so depending on your need, you might have to convert them. You might be better using %Y which will give you the value in seconds since the Epoch (1970-01-01 00:00:00) and then convert to the time format you want, perhaps with date if your system supports the -d flag.
Have a try and let us know if that helps or where you get stuck.
Ah, I should not have quoted the line array=("${array_val}")
Try is with array=(${array_val}) for the last line instead. Does that help?
You might need to work with line 6 too, perhaps this would be better overall:-
Code:
array_val=""
for filename in *
do
timestamp=$(stat -c %Y $filename)
## Trim the timestamp as required or adjust it to your required format
array_val="${array_val} ${timestamp},${filename}"
done
array=(${array_val})
for item in 0 1 2 3 4 5
do
echo "Value for item $item is ${array[$item]}"
done
The date/time value is in seconds from the Epoch, else the array would split up. is that a problem? We can work on fixing it if we need to.
How to copy multiple directories using single command on solaris 10 from server A to server B.
I tried scp but its working only one directory at atime
How to acheive this with simple and short solution????? (6 Replies)
Hi,
I need to query Oracle database for 100 users. I have these 100 users in a file. I need a shell script which would read this User file (one user at a time) & query database.
For instance:
USER CITY
--------- ----------
A CITY_A
B CITY_B
C ... (2 Replies)
Hi,
I have a requirement as below which needs to be done viz UNIX shell script
(1) I have to connect to an Oracle database
(2) Exexute "SELECT field_status from table 1" query on one of the tables.
(3) Based on the result that I get from point (2), I have to update another table in the... (6 Replies)
I would like to use the result of a query in another query. How do I redirect/add the output to another variable?
$result = odbc_exec($connect, $query);
while ($row = odbc_fetch_array($result)) {
echo $row,"\n";
}
odbc_close($connect);
?>
This will output hostnames:
host1... (0 Replies)
I normally download a directory recursively using:
scp -r <name>@host:<path> .
This has worked fine. As everyone knows this will download all of the directory named in <path> and all of the sub directories.
I would like to know if it is possible to not download a particular file if it... (5 Replies)
Hi Friends,
I need to execute a scp command to transfer some files from source to target server. Unfortunately the ftp is not working in my case.
This scp command needs to be executed via Unix script.
I need to know the complete scp command which includes the user-id and password of the... (2 Replies)
Hi all,
i have a directory in server A. the directory path is /home/kevin. I need to scp the directory to another server B. i would like to ask, when i do a scp of the /home/kevin , i can expect all the files from A to go B. However, how about the hidden files? for example the ssh keys in the... (4 Replies)