ArcMap Join Validation Error Help

Question

Hi,

I am getting consistent error on joining 46k records from Arcmap Feature to CSV.

Field names containing invalid characters ' ' (screenshot attached for complete error)

I have done following but not luck

1. removed spaces in Excel (do i remove space in arcmap column)

2. checked text format (changed original data format in excel to text and default format didn't help)

3. removed few columns

I am joining on Location_Final Column.

Owner IDAddressCityTelephoneLocation_Final

000111731 King Street , 111th FloorMycity, AD 9055461111Sec-1 Row-2 Aisle-64000121831 King Street East, 113th FloorMycity, AD9055460000Sec-1 Row-2 Aisle-65

rajujee · Answer

Thanks Darrin. I don't find any Hex characters. Other thoughts?

rajujee · Answer

Thanks Dan. I have text field to join/connect/ It doesn't fix. Any other help!

Darrin-Smith · Answer

Research removing hex characters in Excel.  These would be characters you cannot see that will definitely cause join to fail.