Re: prevent import of control chars

["Andreas J. Guelzow" <aguelzow pyrshep ca>]

HI,

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...

Andreas

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
> https://mail.gnome.org/mailman/listinfo/gnumeric-list