Forum Moderators: phranque

Message Too Old, No Replies

Filtering/Removing certain test in csv

using openoffice

         

operafan

2:39 am on Dec 10, 2003 (gmt 0)

10+ Year Member



Hi, I'm usin openoffice here & have imported a .csv file/ a log file actually into it. It shows all in 1 column but each in their own rows.
My problem is I dont know how to extract basd on certain keywords to show while the rest can be deleted.
Help appreciated

hanuman

8:42 am on Dec 11, 2003 (gmt 0)

10+ Year Member



working with csv, you might want to check CSVdb, a tiny freeware that does excellent job.

[home.hccnet.nl...]

sun818

8:46 am on Dec 11, 2003 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member Top Contributors Of The Month



thanks hanuman, that's a neat tool.

operaman, sounds like you should become with grep, a command line utility that will select lines based on keywords. Native to unix, but you can also find freeware version for Windows (Win32).

operafan

2:05 am on Dec 12, 2003 (gmt 0)

10+ Year Member



Thanks guys, I thought my questions would never be answered.
At least I have some direction :)