[PLUG] Data extraction

Fred James fredjame at fredjame.cnc.net
Mon Apr 5 02:16:07 UTC 2010


drew wymore wrote:
> On Sun, Apr 4, 2010 at 3:50 PM, Fred James <fredjame at fredjame.cnc.net> 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
>> PLUG at lists.pdxlinux.org
>> 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




More information about the PLUG mailing list