Field Names with Brackets
I am importing data from a system that kicks out a csv file with pre-defined column headings. Some of those headings include square brackets, such as photo-hyperlink[0]. I will be importing many of th...
Forum Discussion
Hi Mark,
I have a similar issue, where the brackets are in the field name. Here's an example of the field name:
291 Core Subjects EC-6 - 802 MATH- Requires ProctorU LockDown Browser [Total Pts: 40 Score] |289212
I did not include the brackets on either side so you can see the actual field name being imported from an external source. I have another field that simply looks at this field (numeric formula) so I can use it in other formulas. How would escape work with this field? I'd appreciate any help and thanks!
Marc
------------------------------
Marc Barry
------------------------------
I have a similar issue, where the brackets are in the field name. Here's an example of the field name:
291 Core Subjects EC-6 - 802 MATH- Requires ProctorU LockDown Browser [Total Pts: 40 Score] |289212
I did not include the brackets on either side so you can see the actual field name being imported from an external source. I have another field that simply looks at this field (numeric formula) so I can use it in other formulas. How would escape work with this field? I'd appreciate any help and thanks!
Marc
------------------------------
Marc Barry
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendThis tested OK:
Try this using this is a formula
[291 Core Subjects EC-6 - 802 MATH- Requires ProctorU LockDown Browser [Total Pts: 40 Score\] |289212]
note the backslash escaper character \ before the closing ]
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Try this using this is a formula
[291 Core Subjects EC-6 - 802 MATH- Requires ProctorU LockDown Browser [Total Pts: 40 Score\] |289212]
note the backslash escaper character \ before the closing ]
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- That did it! Thank you!
------------------------------
Marc Barry
------------------------------