Stop Formula Highlighting in Field Names With Parentheses

[Kenda]

I use the field name auto-complete feature whenever I can. One issue with it, however, is when there are parentheses in a field name. After auto-completing the field name, Alteryx highlights a portion of the field name after the first parenthesis. This is not ideal as I typically expect the cursor to be at the end of the field name so I may continue to type. In this scenario, unfortunately, I would begin to type over my field name and the expression gets messed up. 

For example, as shown below, I begin to type "st" and then hit the tab button to complete the field name in my expression.

In this case, because my field name has parentheses in it, however, some of the field name remains highlighted and the cursor does not go to the end of the right bracket, as one would expect.

If I were to continue typing at this point, the highlighted portion of the expression would get erased and replaced. 

Field names that do not contain parentheses continue to function correctly as shown below. 

[mbarone]

Yes, this is sooooo annoying!

[patrick_digan]

yes please!

[smoskowitz]

Working in finance (Tax) field names regularly have something like Balance (Dr/Cr.) in it. Kenda's proposed idea would benefit us.

Thanks,

Seth

[Hollingsworth]

Yes, yes, yes, yes. Please do this.

Also, @Kenda when we discussed this pain point at the ACE roundtable, I knew I had found a kindred spirit.

Thanks for posting!

[KylieF]

Thank you for your feedback and such a thorough idea! I know it seems silly but the pictures are a great help for our product team.

All the engagement on this idea is already great, but be sure to share this idea, as it really helps us get a grasp on how interested users might be in this feature.

[Eli_B]

OMG, please fix this!

[mst3k]

Adding onto this because you have spaces as well-

If you start typing "[State Co"

The predictor will suggest [State Code (FIPS)], but if you select it, it will only replace the "Co" so you wind up with:

[State [State Code (FIPS)]

and you get immediate errors. If you start typing a field with an open left bracket [ then selecting a predicted field should replace everything back to that bracket

[Kenda]

Good point @mst3k I agree, Alteryx should be able to know where the start of the field name is based on the open bracket and replace the whole beginning part your typed.

[TheOC]

This is a great idea - this trips me up every time, especially when I try to keep typing and 'autopilot' the rest of my formula.