AnsweredAssumed Answered

Why is ArcGIS Pro Query Definition converting strings with commas?

Question asked by majeHTG on Aug 15, 2019
Latest reply on Aug 16, 2019 by KKramer-esristaff

Hi all,

I have a field containing values that are comma separated lists [e.g. '1, 2, 3', '6', '2, 5, 9']. Note that this is three strings marked by single quotes.

 

I try to use values from this field in a definition query like so:

But, as soon as I close the dialog, the values get converted to a list of the individual values as strings - instead of three values, there are now 7 values ['1', '2', '3', etc.]:

ArcGIS Pro incorrectly converts the values

Only the value without a comma, '6',  is now correct.

 

I realize I can work around this by adding a field and converting the commas to some other character but I feel like this should not be necessary. Why is ArcGIS Pro altering the strings?

 

[I am using ArcGIS Pro 2.4.0 on a Windows 10 machine]

Regards,

MJ

Outcomes