s/\|\|/|\\N|/; #### s/\|(?=\|)/|\\N/g; s/^\|/\\N|/; s/\|$/|\\N/; #### perl -pe"s/\|(?=\|)/|\\N/g; s/^\|/\\N|/; s/\|$/|\\N/" infile >outfile