Expression for column with spaces

[dankitchen]

Hi Team,  I have a sType where I created the columns by importing a spreadsheet where some column names had spaces.  It seems to have created the columns with spaces that are ok to reference in the filter part of an expression but not for a column reference in a @GET expression.  An example is:

Code:

email_expr = "@GET(msm/wp_orders['Order Status', 'Processing'].Email Billing)"
email_list = server.eval(email_expr)

I tried a few things and also double-checked in psql that the spaces are there.  I had thought that Tactic replaced the spaes in column names during csv import but seems to not be the case now. 

thanks!
-Dan

[dankitchen]

I realized one way around this is to do the following but still interested to know if there is a way to address the above issue

order_expr = "@SOBJECT(msm/wp_orders['Order Status', 'Processing'])"
order_list = server.eval(order_expr)

email_list = []

for order in order_list:
email_list.append(order.get("Email Billing"))


email_html = ",".join(email_list)

[listy]

Hi!
Have you tried using "\s" for space?

Code:

email_expr = "@GET(msm/wp_orders['Order Status', 'Processing'].Email\sBilling)"
email_list = server.eval(email_expr)

[remkonoteboom]

Yes, I can see the expression parser messing that up. Does listy's suggestion work (I would like to know)?

In general, spaces in column names are "frowned" upon for these kinds of reasons (just like file names). You never know where it will break. However, if (and I mean if ... ) it were to be supported, I would think that it would require something like this:

@GET(msm/wp_orders['Order Status', 'Processing'].'Email Billing') <-- with single quotes around Email Billing.

(NOTE above is not supported, in case anybody reads too quickly)