Re: prevent import of control chars


if it is a single one-time file you could open it in Gnumeric, use search and replace to remove the newlines and then export it...


On 16-07-17 11:33 AM, Bee wrote:
I inherited an Excel spreadsheet.
The Excel file has many sheets.
It has some 0x0a LineFeed control chars in strings.
I can remove them search (regex) for '\n' and replace with nothing.

Is there a way to remove the LineFeed on import?
Or using ssconvert to save as text?

The following works great to export each sheet as a file, except for the unwanted LineFeed chars.

ssconvert -O 'format=raw separator=;' -S book.xlsx %s.txt

gnumeric-list mailing list
gnumeric-list gnome org

[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]