[PLUG] Reformating(best word?) spreadsheet data

[Richard Owlett]

On 06/07/2019 01:30 PM, Fred James wrote:
> Richard Owlett wrote:
>> I heavily use SeaMonkey's Mail/News tagging feature (currently ~50 
>> unique tags). I extracted the appropriate lines from prefs.js and 
>> edited it such that Gnumeric read it as CSV.
>>
>> It displays it as:
>>> label1    color    #FF0000
>>
>>> label1    ordinal    $lg
>>
>>> label1    tag    Important
>>
>>> label2    color    #990000
>>
>>> label2    ordinal    $lb
>>
>>> label2    tag    "re repository"
>>
>>> label3    color    #99FFFF
>>
>>> label3    ordinal    $ld
>>
>>> label3    tag    Personal
>>
>>
>> I want it to look like:
>>> label1    #FF0000    Important
>>
>>> label2    #990000    "re repository"
>>
>>> label3    #99FFFF    Personal
>>
>>
>> I've not done anything with spreadsheets in DECADES.
>> {Lotus and Visicalc were only game in town}
>>
>> Suggestions &/or reading assignment?
>> TIA
> Richard Owlett
> See below for "Script", "Input File", and "Output File" ... this is a 
> BASH script, containing some SED and GAWK lines ... someone else may be 
> able to do that more elegantly?
> Hope that helps, or at least is a starting point
> Regards
> Fred James
> [snip the script]

I've not done much with bash. This gives me a good starting point for 
exploring it. Your code suggests how I can process prefs.js directly 
rather than going thru my spreadsheet kludge as intermediate step.

Thank you