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.]:
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]