HomeHome ArchiveArchive

Openoffice: Replace <13><10> in CSV

After importing a CSV document (comma separated table) there were sequences of litteral “<13><10>” text in some of the cells in Openoffice.

What you need to do is to replace them by a newline with a text editor, before importing them n Openoffice.

In vim you do that by opening the file, marking the whole document with “V0G”, and then replacing all the occurences of “<13><10>” with a newline by issuing “:s/<13><10>/Ctrl-VEnter/a”, where Ctrl-V is pressing down the Ctrl key and then the ‘v’ key and Enter is pressing the “Enter” key.

Tomáš Pospíšek