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




_______________________________________________
PLUG mailing list
[email protected]
http://lists.pdxlinux.org/mailman/listinfo/plug

Reply via email to