[Libreoffice-bugs] [Bug 138472] Calc enhancement: ignore rows when importing CSV

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Thu Nov 26 16:04:23 UTC 2020


https://bugs.documentfoundation.org/show_bug.cgi?id=138472

--- Comment #4 from V Stuart Foote <vstuart.foote at utsa.edu> ---
(In reply to m.a.riosv from comment #3)
> With a few steps can be done after import, with more flexibility.
> 
> On the sheet, e.g. select the column with the text to find, [Ctrl+H]"Find &
> Replace", search for the string(s), Find All, click on the sheet window
> title (to retain selected founded cells) and [Ctrl-] to delete all rows with
> founded cells.

Yes true except, pre-filtering the Text Import dialog could eliminate unwanted
stanzas/rows from the source CSV before they are parsed against the field
separators--both improving the accuracy of the data import, and avoiding need
to clean up data after the import.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201126/277e0a8e/attachment.htm>


More information about the Libreoffice-bugs mailing list