prevent import of control chars
- From: Bee <beeyawned gmail com>
- To: gnumeric-list gnome org
- Subject: prevent import of control chars
- Date: Sun, 17 Jul 2016 10:33:11 -0700
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
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]