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- _______________________________________________ PLUG mailing list [email protected] http://lists.pdxlinux.org/mailman/listinfo/plug
