On Sun, Apr 4, 2010 at 7:16 PM, Fred James <[email protected]> wrote: > 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 >
Definitely Unix/Linux Fred ;-) I'd feel dirty using Windows. Drew- _______________________________________________ PLUG mailing list [email protected] http://lists.pdxlinux.org/mailman/listinfo/plug
