Date: prev next · Thread: first prev next last
2016 Archives by date, by thread · List index


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.
It worked!
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?

Thank you.

Felipe  : )

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: 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.