Proper syntax to color cells where column name has a space

senatorx — Thu, 22 Aug 2013 15:12:22 GMT

Hi, I found in the forums that you can color table cells by sending the color cells(...) command to a table column.

It works fine when sending to a column with no spaces in the column name, such as ":Roast", however a column title with a space fails. What is the proper syntax for column names with spaces?

Thanks.

---------------------------------------------------------------

coffee_dt = New Table();

coffee_dt << New Column("Coffee Name", Character, Nominal);

coffee_dt << New Column("Roast", Character, Nominal);

coffee_dt << AddRows(2);

Column("Coffee Name")[1] = "Veranda";

Column("Coffee Name")[2] = "Pike Place";

Column("Roast")[1] = "Medium";

Column("Roast")[2] = "Dark";

:Roast << color cells("red", coffee_dt << get rows where(:Roast=="Medium"));

Column("Coffee Name") << color cells("green", coffee_dt << get rows where(Column("Coffee Name")=="Pike Place"));

Re: Proper syntax to color cells where column name has a space

pmroz — Thu, 22 Aug 2013 15:53:29 GMT

This syntax works:

:Coffee Name << color cells("green", coffee_dt << get rows where(:Coffee Name == "Pike Place"));

It doesn't like column("Coffee Name") in the where clause for some reason. If you have strange characters in the column name you can use the :name() construct. This works:

Column(coffee_dt, "Coffee Name") << color cells("green", coffee_dt << get rows where(:name("Coffee Name")=="Pike Place"));

topic Proper syntax to color cells where column name has a space in Discussions

Proper syntax to color cells where column name has a space

Re: Proper syntax to color cells where column name has a space