Filter a string field by its length

AngelaSchirck — Wed, 11 Oct 2023 14:22:58 GMT

I have a parcels layer and a table widget in EB developers ed 1.12 (latest release). I have 10-digit parcel numbers and 17-digit parcel numbers, but they are in the attribute table as strings. I need to filter out all 10-digit parcel numbers, but the filter widget does not allow for writing your own SQL statement (this would be a very simple task if it would). When I use the "build sql expression" tool for parcel number my choices are:

(the last choice not see is "is not blank.")

Does anyone know a way to filter out these nearly 2800 10-digit parcel numbers without entering them one-by-one?

ESRI: Can you PLEASE add an option to edit/type your own SQL statement in the filter widget??

Re: Filter a string field by its length

JeffreyThompson2 — Wed, 11 Oct 2023 14:48:28 GMT

Try Contains _________________

That is 17 underscore characters. Underscore is the single character wildcard in SQL.

https://www.w3schools.com/sql/sql_wildcards.asp

Re: Filter a string field by its length

AngelaSchirck — Wed, 11 Oct 2023 15:35:43 GMT

Perfect! Thanks!

topic Re: Filter a string field by its length in ArcGIS Experience Builder Questions

Filter a string field by its length

Re: Filter a string field by its length

Re: Filter a string field by its length