Can I change the decimal symbol from a dot to a comma?
Posted: Tue May 26, 2020 11:30 am
Can I change the decimal symbol from a dot to a comma?
Forum for questions on the use of GAMS
https://forum.gamsworld.org/
Code: Select all
dummy;new-york;chicago;topeka
seattle;2,5;1,7;1,8
san-diego;2,5;1,8;1,4
Code: Select all
* translate , to . using tr
$call "tr , . <input.csv >temp.csv"
* translate ; to , using tr
$call "tr ; , <temp.csv >output.csv"
table data(*,*)
$ondelim
$include output.csv
$offdelim
;
display data;
Code: Select all
* translate , to . and ; to , using sed
$onecho > sedscript
s/,/./g
s/;/,/g
$offecho
$call sed -f sedscript input.csv > output.csv
table data(*,*)
$ondelim
$include output.csv
$offdelim
;
display data;
Code: Select all
---- 14 PARAMETER data
new-york chicago topeka
seattle 2.500 1.700 1.800
san-diego 2.500 1.800 1.400