drew wymore wrote: > On Sun, Apr 4, 2010 at 3:50 PM, Fred James <[email protected]> wrote: > >> drew wymore wrote: >> >>> [omissions for brevity] >>> >>> Thanks Rich and Michael. I'll give the perl a shot and see what >>> happens. As far as the data layout. It's 5 columns with roughly 1100 >>> rows, the column I'm interested in has a variable number of words per >>> entry but doesn't exceed a couple hundred words. >>> >>> I did enable fulltext searching within mysql which works fine for >>> searching but doesn't give me the flexibility I'm looking for to >>> actually just get a count of unique words. I did find something in PHP >>> that is supposed to work but it's barfing on the array that's being >>> returned by the mysql query. >>> >>> Drew- >>> >>> >> drew wymore >> So you extract 1100, 5 column records into a cvs file? I take it you have >> that part down pat? >> OK, so is there something special going on, or could a spreadsheet handle >> your task? For example: is this a quick, once and done task? >> Regards >> Fred James >> >> PS: OOo spreadsheets will open cvs files either as comma separated, tab >> separated (etc), or as fix length fields >> >> >> _______________________________________________ >> PLUG mailing list >> [email protected] >> http://lists.pdxlinux.org/mailman/listinfo/plug >> >> > > Fred, > It's a monthly task that I'll be working with. The number of rows are > variable but the columns are static, definitely have this down pat in > terms of the export from Oracle. I have yet to find a routine within a > speadsheet that gives me the desired results but I'm open to any and > all suggestions. I've been working for a few days on this to try and > find a reasonable and repeatable solution I can use for this task. > > Drew- > drew wymore Assuming (since this is a Linux list) the platform is Unix/Linux ... I am an AWK man myself and that would be my choice. Don't know if that helps, but I hope so Regards Fred James
_______________________________________________ PLUG mailing list [email protected] http://lists.pdxlinux.org/mailman/listinfo/plug
