HI All,


I have a text file memory.txt which has following values.

   Average:       822387   7346605     89.93    288845   4176593   2044589     51883      2.47      7600

  sed s/_/\./g < memory.txt | awk -F. '{ print $1","$2","$3","$4}' > test.csv

awk -F_ '{ print $1","$2","$3}' < memory.txt >  MemoryTemp.csv

Since the 1st awk code just handles only first 3 fields you only get first 3 fields. There is also a substitution of underscores where there aren't any. So a following underscore as field separator is not working either. This code does not fit to your question at all. You can try this one - I've chosen the semicolon as separator:

$> sed 's/[[:space:]]\+/;/g' memory.txt > memory.csv
$> cat memory.csv
Average:;822387;7346605;89.93;288845;4176593;2044589;51883;2.47;7600

Hi,
Try this,

tr -s ' ' ',' < inputfile

Hi,

zaxxon: by choosing , (comma) as a separator, i got the required results. so thanks for your input.

sed 's/[[:space:]]\+/,/g' memory.txt > memory.csv