Discussion :

[DevAlag]

Bonjour,
J'ai un script extrait des valeurs d'un fichier (speedtest) dont le contenu est du type

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
 
##"ORANGE FRANCE - Puteaux","23884","3.5467","0.32625","0","26577418","8390410","364999650","91138521","https://www.speedtest.net/result/c/c643aa2b-5046-4013-aefe-3fdf7044977f","1","17.9035","26.4743","2.991","257.569","4.27329","2.50788","2.273","57.746","3.194","3.789"
##
#!/bin/bash
var=$(cat $1)
Server_Name=$(echo $var | cut -d"," -f1-1)
Server_ID=$(echo $var | cut -d"," -f2-2)
Server_Ping=$(echo $var | cut -d"," -f3-3)
Download=$(echo $var | cut -d"," -f6-6)
Upload=$(echo $var | cut -d"," -f7-7)
LienResultat=$(echo $var | cut -d"," -f10-10)
## problème sur cette ligne !
Download=$(echo "scale=3; $Download/ 125000" | bc | awk '{printf "%.2f\n", $0}')
#...

si j'exécute le script j'obtiens

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
 
bash trancheHoraire.sh file.cvs
(standard_in) 1: syntax error

Si je lance cette commande dans terminal, ça fonctionne !
Avez-vous une idée sur le problème ?

[jack-ft]

Et hop! Un p'tit coup de debug (trace) pour voir ce qu'il fait:

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
% bash -x trancheHoraire.sh file.cvs
++ cat file.cvs
+ var='##"ORANGE FRANCE - Puteaux","23884","3.5467","0.32625","0","26577418","8390410","364999650","91138521","https://www.speedtest.net/result/c/c643aa2b-5046-4013-aefe-3fdf7044977f","1","17.9035","26.4743","2.991","257.569","4.27329","2.50788","2.273","57.746","3.194","3.789"'
++ echo '##"ORANGE' FRANCE - 'Puteaux","23884","3.5467","0.32625","0","26577418","8390410","364999650","91138521","https://www.speedtest.net/result/c/c643aa2b-5046-4013-aefe-3fdf7044977f","1","17.9035","26.4743","2.991","257.569","4.27329","2.50788","2.273","57.746","3.194","3.789"'
++ cut -d, -f1-1
+ Server_Name='##"ORANGE FRANCE - Puteaux"'
[je snippe un peu]
++ echo '##"ORANGE' FRANCE - 'Puteaux","23884","3.5467","0.32625","0","26577418","8390410","364999650","91138521","https://www.speedtest.net/result/c/c643aa2b-5046-4013-aefe-3fdf7044977f","1","17.9035","26.4743","2.991","257.569","4.27329","2.50788","2.273","57.746","3.194","3.789"'
++ cut -d, -f6-6
+ Download='"26577418"'
[je snippe encore un peu]
++ echo 'scale=3; "26577418"/ 125000'
++ bc
++ awk '{printf "%.2f\n", $0}'
(standard_in) 1: parse error
+ Download=

Je teste un peu à la mano pour voir:

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
% echo 'scale=3; "26577418"/ 125000' | bc
(standard_in) 1: parse error

Ça se confirme ! bc n'aime pas qu'on divise une chaine par un nombre...

PS: Par ailleurs, quelle drôle d'idée d'appeler "file.cvs" un fichier qui semble plus "comma separated values" que "Canvas format"

[DevAlag]

Merci Jack,
Pourtant ça marche en ligne de commande.
&Download converti mais pas en script.
Comment convertir "1234567" en 1234567 dans le script ?

[Flodelarab]

Bonjour

Code bash :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
$ awk -F '","' '{sub(/^./,"");sub(/.$/,"");} {for (i=1;i<=NF;i++) print $i;}' <<eof
> "ORANGE FRANCE - Puteaux","23884","3.5467","0.32625","0","26577418","8390410","364999650","91138521","https://www.speedtest.net/result/c/c643aa2b-5046-4013-aefe-3fdf7044977f","1","17.9035","26.4743","2.991","257.569","4.27329","2.50788","2.273","57.746","3.194","3.789"
> eof
ORANGE FRANCE - Puteaux
23884
3.5467
0.32625
0
26577418
8390410
364999650
91138521
https://www.speedtest.net/result/c/c643aa2b-5046-4013-aefe-3fdf7044977f
1
17.9035
26.4743
2.991
257.569
4.27329
2.50788
2.273
57.746
3.194
3.789

Code bash :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
$ awk -F '","' '{sub(/^./,"");sub(/.$/,"");} {print $6/12500;}' <<eof
"ORANGE FRANCE - Puteaux","23884","3.5467","0.32625","0","26577418","8390410","364999650","91138521","https://www.speedtest.net/result/c/c643aa2b-5046-4013-aefe-3fdf7044977f","1","17.9035","26.4743","2.991","257.569","4.27329","2.50788","2.273","57.746","3.194","3.789"
eof
2126.19

PS : l'erreur pointée précédemment vient de la différence entre le vide et zéro.

[N_BaH]

Code bash :

Sélectionner tout - Visualiser dans une fenêtre à part

$ awk ...

[N_BaH]

Code BASH :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
$ IFS=',' read -ra array <<<'"ORANGE FRANCE - Puteaux","23884","3.5467","0.32625","0","26577418","8390410","364999650","91138521","https://www.speedtest.net/result/c/c643aa2b-5046-4013-aefe-3fdf7044977f","1","17.9035","26.4743","2.991","257.569","4.27329","2.50788","2.273","57.746","3.194","3.789"'
$ strip() { pat=$1; shift; expr=$@; out=${expr/#$pat/}; echo ${out/%$pat/};}
$ strip '"' "${array[0]}" #par exemple, avec le premier élément du tableau
ORANGE FRANCE - Puteaux
$