[PLUG] Reformating(best word?) spreadsheet data

Richard Owlett rowlett at cloud85.net
Fri Jun 7 13:12:32 UTC 2019


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





More information about the PLUG mailing list