topic Re: Help with selecting similar names from two columns in ArcGIS Pro Questions

Help with selecting similar names from two columns

Aique — Mon, 20 Feb 2023 17:22:30 GMT

Hello

I have two columns with the names OWNER_NAME1 and BIZ_NAME.

The data is messy, so the business name and owner name may not be the same - but might be similar.

I want to select the records where the names in the two columns are similar.

I tried this but it says the expression is invalid.

BIZ_NAME = BIZ_NAME LIKE CONCAT(%OWNER_NAME1%) OR OWNER_NAME1 LIKE CONCAT(%BIZ_NAME%);

Please advise,

Thank you,

DavidPike — Mon, 20 Feb 2023 17:37:14 GMT

What's CONCAT meant to be doing? Get rid of it.

Aique — Mon, 20 Feb 2023 17:45:36 GMT

BIZ_NAME = BIZ_NAME LIKE (%OWNER_NAME1%) OR OWNER_NAME1 LIKE (%BIZ_NAME%);

Start Time: Monday, February 20, 2023 11:45:23 AM

ERROR 000358: Invalid expression

Failed to execute (SelectLayerByAttribute).

Failed at Monday, February 20, 2023 11:45:23 AM (Elapsed Time: 0.04 seconds)

Aique — Mon, 20 Feb 2023 17:45:52 GMT

Still returned an error without Concat

Aique — Mon, 20 Feb 2023 17:50:53 GMT

Biz name might be Sporty and Owner name might be Sporty Associates LLC

DavidPike — Mon, 20 Feb 2023 17:56:27 GMT

where are you using this expression? what tool etc as it is important

DavidPike — Mon, 20 Feb 2023 19:43:41 GMT

Apologies I didn't understand quite the complication of this (long day).

perhaps:

BIZ_NAME LIKE('%' || OWNER_NAME || '%') OR OWNER_NAME LIKE('%' || BIZ_NAME || '%')

NB I can't remember if LIKE is case sensitive in feature classes