Using the node.js or sed command to replace the text in yo.txt file

README.md

Structure

foo
    data
        yo1.csv
        yo2.csv
    Makefile
    yo1.js
    yo2.js

Makfile

run:
    sed 's/"\([[:alnum:]]*\),\([[:alnum:]]*\)"/"\1:\2"/g' data/yo.csv > data/yo.sed.csv

test:
	@echo "a,b,c,d,e,\"a,b\",f,g,\"h,i\",j,k\n1,2,3,4,5,\"6,7\",8,9,\"10,11\",12,13" | \
		sed 's/"\([[:alnum:]]*\),\([[:alnum:]]*\)"/"\1:\2"/g'

yo1.csv

yo1.js

#!/usr/bin/env node

var fs = require('fs');

fs.readFile('data/yo1.csv', function(err, data) {
    data.toString().split("\r\n").forEach(function(line) {
		line = line.replace(/"([A-Za-z0-9]+),([A-Za-z0-9]+)"/g, '"$1:$2"');

		console.log(line);
	});
});

yo2.csv

yo2.js

#!/usr/bin/env node

var fs = require('fs');

fs.readFile('data/yo2.txt', function(err, data) {
    data.toString().trim().split("\n").forEach(function(line) {
		var matches = line.match(/"(.*?)"/g);

		for(var i=0, l=matches.length; i<l; i++) {
			line = line.replace(matches[i], matches[i].replace(/,/g, ":"));
		}

		console.log(line);
	});
});