Load a field that includes [ ] and spaces in name

[adinepstein]

Hi,

I have a field name called '[CHART] Time in Status'.

when I load the following I get a syntax error :

StatusTime:

LOAD

Key

,[[CHART] Time in Status] as timeStatus

FROM...

Any ideas how to solve the problem?

Thank you

Adin

[m_woolf · Accepted solution]

Have you tried double quotes?

"[CHART] Time in Status" as timeStatus

[adinepstein]

You are right- it works.

thank you for your quick respond.