Reference fields with square brackets

Question

I have a field called "Field[1]" and the square brackets in the name interferes with the square brackets denoting a field. Looks like you can add a second closing square bracket, but I wondered why that was the case? Anybody got an explanation? Is this documented?

flying008 · Answer

Hi, @PhilipMannering

If your field name contains  a right square bracket ']', then it will be eat by formula before parse(because it always matched 1st '['), to avoid the case, you need manual added a ']' to padding it each position.

Qiu · Answer

@PhilipMannering 
I searched the Help doc and get no luck, I guess it is not documented yet?

2 square bracket mean anything in your programing world? 😁

But I did find one in the community related.

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Parse-Error-at-char-1-Unknown-variable-amp-quot-My-variable-amp/td-p/66781

PS: New profle pic still not matches the person I see at the Inspire.🤣