convert file with :: delimiter into csv: awk -v 'FS=::' '{print $1 "," $2 "," $3}' ratings.dat >> ratings.csv