Run a remote awk command using ssh

Question

I try to run a remote awk statement using ssh. My code is:

ssh username@hostIP "awk 'NR==1  {max=0;min=1} NR>1 {if (max<\$3) max=\$3}END {print max}' FS=\",\" /path_to_my_file"

When I run this command, I receive no error message, but command is not working and doesn't produce an output but just hanging so I would need to cancel it by ctrl+c.

Is there something I am missing?

what is that `FS=` doing there after the `awk` command? Maybe you meant to do `awk -v FS=, '...'` instead? — janos, Nov 15 '13 at 22:06
janos is right, I think double quote after FS is confusing ssh whereas I used \ to escape them, but it looks it didn't work. With the format like ssh username@hostIP "awk -v FS=, 'NR==1 {max=0;min=1} NR>1 {if (max<\$3) max=\$3}END {print max}' /path_to_file " the command produced desired result. Thanks. — JavaRed, Nov 15 '13 at 22:39

Gilles Quénot · Accepted Answer · 2013-11-16T02:08:48.887

10

Try this using a here-doc :

ssh -t username@hostIP <<'EOF'
awk '
    NR==1 {max=0;min=1}
    NR>1 {if (max<$3) max=3}
    END {print max}
' FS="," /path_to_my_file
EOF

The single quotes around EOF prevent shell expansion.

edited Nov 16 '13 at 02:08

answered Nov 15 '13 at 22:02

Gilles Quénot

173,512
41
224
223

I received Pseudo-terminal will not be allocated because stdin is not a terminal error message. – JavaRed Nov 15 '13 at 22:40
Just a warning I think. – Gilles Quénot Nov 15 '13 at 23:07
1

It worked with -t -t option. Just to force pseudo-tty allocation even if stdin isn't a terminal. – JavaRed Nov 16 '13 at 01:29
@StardustOne I am stuck with a similar problem here http://stackoverflow.com/questions/31007951/running-awk-command-in-remote-host-fails – RajSanpui Jun 23 '15 at 16:43
Thank you. I've been struggling with this. – SaxDaddy Feb 18 '16 at 19:55

Run a remote awk command using ssh

1 Answers1

Linked

Related