OpenEuphoria

Re: Grid in vlookup

• Posted by irv Mar 18, 2019
• 928 views

You may be able to see the utility of the $ when your data is entered like this:

constant fruits = {--name,unit,price,   tooltip; 
	{"Apples",	"doz",	3.50,	"Mackintosh"}, 
	{"Cherries",    "lb",	2.69,	"Bing"}, 
	{"Dates",	"lb",	6.99,	"Medjool"}, 
	{"Limes",	"ea",	 .59,	"Key"}, 
	{"Oranges",	"ea",	 .79,	"Valencia"}, 
	{"Bananas",	"lb",	 .89,	"Dole"}, 
	$} 

Without that $, the last entry would be

        {"Bananas",	"lb",	 .89,	"Dole"}} 

Requiring you to go back, insert a comma, lf, then add another entry. Just a convenience. More often, it helps when you need to comment out the last entry. If written as directly above, commenting out Bananas would result in an error, since the closing } for the fruits would not be there.