Subscribe Bookmark RSS Feed

Proper syntax to color cells where column name has a space

senatorx

Community Trekker

Joined:

Jun 12, 2012

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"));

1 ACCEPTED SOLUTION

Accepted Solutions
Solution

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"));

1 REPLY
Solution

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"));