Issue with Derived Column Plus handling of column names including space

18 views
Skip to first unread message

John Nickell

unread,
Apr 10, 2024, 4:13:56 PM4/10/24
to COZYROC
If I create an expression that consist of only a valid column and the column name has no spaces in the name the "Evaluation Result" pane shows the correct "Test String".

If the column name has a space in it, I get "SyntaxError: Expected operator but found 'Name'"

Here's what the Script section shows. Column 1 works, Column 2 doesn't. (Project Name has a space in it)

{ dataType: DataType.DT_WSTR, length: 1000, name: "LeadDesc", expression: "[City]\r\n" },
{ dataType: DataType.DT_WSTR, length: 250, name: "ProjectDesc", expression: "[Project Name]" }];
Reply all
Reply to author
Forward
0 new messages