Search Results

We are able to get the field from csv file using the command
cut -d , -f6 rpt.csv where f6 is the column with cent values.
But how do we convert that column into dollar?

We need to convert a field in a csv file which is in cents to dollars.(divide by 100) in our shell script.
Can some body help me?

ssh $USR@$host /bin/bash <<\EOF >> ship-error.txt
awk 'BEGIN{f=0} !f { s=$0; sub(/,.+/, "", s); gsub(/[-: ]/, " ", s); t=(systime()-mktime(s)); if(t<=14400) f=1 } f ' /logs/shiperror.log
EOF

I...

But we have 3 awk commands like this:
ssh $USR@$host /bin/bash <<EOF
awk ' BEGIN{f=0} !f { s=$0; sub(/,.+/, "", s); gsub(/[-: ]/, " ", s); t=(systime()-mktime(s)); if(t<=14400) f=1 } f '...

ssh $USR@$host /bin/bash <<EOF
awk ' BEGIN{f=0} !f { s=$0; sub(/,.+/, "", s); gsub(/[-: ]/, " ", s); t=(systime()-mktime(s)); if(t<=14400) f=1 } f ' /home/error.log >> error.txt
EOFWe are trying...

We are remoting to six different servers,so the error file is getting created in these 6 servers.We need to append all these into a single file in our local machine so that we can mail it.So we are...

Thanks kevin.It worked with some modifications.
ssh user@IP /bin/bash <<\EOF
awk ' BEGIN{f=0} !f { s=$0; sub(/,.+/, "", s); gsub(/[-: ]/, " ", s); t=(systime()-mktime(s)); if(t<=14400) f=1 } f '...

in the script while using the awk command with ssh like:
ssh user@IP awk 'BEGIN{f=0} !f { s=$0; sub(/,.+/,\"\", s); gsub(/[-: ]/,\" \", s);t=(systime()-mktime(s)); if(t<=14400) f=1 } f'...

I think it should check the date condition first. here is how i get the outfile as:

2010-11-20 14:59:39,960 ERROR
Shipment Error Log:Error Details - Account Id:3962, PO:2573485,...

Thanks for your quick response.

We checked using your code.But still it copies all the logs in the file without checking the condition:(

Our log file looks like this:
2010-11-18 00:57:01,698 ERROR
Shipment Error Log:Error Details - Account Id:3962, PO:2710015, Line:2, File:221112901, Version:V1, Desc:Order cannot...