How do I bind to a field with special characters?

[John]

I am trying to bind a TextBox to an a dynamically named column using expressions.

var textBoxHistorical = new TextBox
{
   Name = "myTextBox",
   Value = "= Fields.[" + ​dynamicColumnName+ "_​Average])",
   Size = new SizeU(Unit.Pixel(100), Unit.Pixel(20)),
   Location = new PointU(Unit.Pixel(0), Unit.Pixel(0))
};

The column name can have ugly characters like \/*[]:?|-+@#$$^&()_,.!3. When I try to bind to Fields.[\/*[]:?|-+@#$$^&()_,.!3_​Average], I get an error like

     Cannot interpret token '\' at position 13.

I tried escaping the slash with another slash, and got the same error. How do I escape characters in an expression? Which characters do I need to escape? I figure I need to escape the closing bracket also, but trial by error is probably not the best way to solve the problem.

[Nasko]

Hello John,

The issue is that the field name itself contains square brackets, which are used by default to enclose the field name. You need to escape those square brackets with a backslash as described in the Global Objects | Fields help article.
For example, the following expression does not produce an error:

= Fields.[\/*\[\]:?|-+@#$$^&()_,.!3_​Average]

Regards,
Nasko
Telerik

[John]

Thank you, Nasko. I created a brand new blank report to test your answer, and it worked. I was able to bind a table to a CsvDataSource that had a column named  \/*[]:?|-+@#$$^&()_,.!3.