in reply to Re: Convert XLSX to TSV and remove CRLF in cells
in thread Convert XLSX to TSV and remove CRLF in cells
'^M' is single character, entered pressing 'ctrl-v enter'in some editors. In others is may end up displaying as some sort of a line feed. [emphasis added]
A better, more portable way of encoding this is \015, \o{015}, \cM, \x0d, or some other encoded form that won't potentially be messed up by an editor, printer, code pretty-printer, ….
--MidLifeXis
|
|---|