Column names with space

I read data from excel then I want to transform one column (col=param+"_"+col) and then I want to write it back.

I use the “Run script on table row” for this, it works well when the column name has no space but it fails otherwise (for instance column called “Trade ID”). How can I do this?

Hi Jerome,

There are 2 ways to address this. Let’s assume your with-space-column is called “Trade ID”

  1. you could use col = Trade_ID
  2. you could also use col = TradeID

Hope that helps. Thanks

Yes that worked, thanks