I'm trying to get a list of items with subfields on a nice table to import
in LO database.
For instance, the output of the listing of the command
# iwlist wlan0 scan > nearby_wifi_nodes
which is a list of the wifi nodes near my router.
I have tried opening the raw text file in LO writer:
try1: converting the list to a table separating text with Tab
--> each line goes to the first cell of a table with 1 column
try2: "Paste Special" the text onto a spreadsheet in calc with
options "transpose" and "skip empty cells" marked
--> I get all the text separated in cells but on only 1 row.
I have tried leaving the text as what I believe is a CSV format by removing
line feeds and replacing them with comas but I have not succeeded since I'm
not able to find the correct code for line feeds in LO writer's
"Find&Replace" dialog. I tried "^p", copied from the end of a line to the
beginning of the next and some other ways. No luck.
I managed to do it with the editor gedit in Gnome: copied the end of a
line to the next, opted for the Replace function and placed a coma instead.
I then proceeded to eliminate the tabs/blank spaces with the same funtion
and I just had to look for ",Cell ", erase the coma and replace it with a
line feed before each appearance. I saved the file with extension .csv.
I then copied the text in this cvs file and pasted it in a new calc
spreadsheet. Viola! I had the file in a nice table. Save for the fields
that I have to rearrange so I have the headers/fields correct to pass them
onto a table in the database.
That is, I got a table like this:
Cell 01 - Address: 00:16:B6:39:7C:10 Channel:6 Frequency:2.437 GHz (Channel 6)
Cell 02 - Address: 54:67:51:22:F4:13 Channel:1 Frequency:2.412 GHz (Channel 1)
Cell 03 - Address: 4C:09:D4:9D:E5:78 Channel:1 Frequency:2.412 GHz (Channel 1)
Cell 04 - Address: 94:4A:0C:BC:18:71 Channel:4 Frequency:2.427 GHz (Channel 4)
and so on. With a lot more columns of course.
- How does one replace linefeeds with whatever?
- Is there a way to do this within LO without having to use an external
editor to get rid of the linefeeds?
- Is there a simpler way to do what i pretend?
Felipe : )
To unsubscribe e-mail to: email@example.com
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
- [libreoffice-users] list of items to a table in LOcalc and then to a db · Felipe T. Dorado
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy