21 Aug
2003
21 Aug
'03
05:47
Does anyone know of a (command line) program in SuSE that allows you to replace all occurences of a certain string in a text (CSV) file with another?
I have a (huge) file which contains Matlab style 'NaN' for missing data and I need to make it Gauss readable by replacing all the 'NaN' with the symbol '.'. It's too big to be loaded into an editor or excel etc.
Using everyone's favourite swiss army chainsaw: perl -pi -e 's/NaN/\./' file.csv Take a backup first! --
eatapple core dump