Appending from a feature class to another removes spaces in string attribute?

[DanielLane]

I am trying to append a select query to an empty feature table, when I do this the string field (Species Name) has the spaces removed and is all lower case?

Original data (SpeciesName):

After append to existing table the data looks like this:

I have tried this with other string fields and the result is the same for all.

What can I do to fix this?

[ChristopherCounsell · Accepted solution]

Is there a domain? If you edit the data, do you get a drop-down  or is it open text?

If there is a domain, it's likely that the domain values are being passed. Coded domain values can't have special characters, including spaces, and are generally shown in tables using their domain label. 

You can use Arcade expressions to choose whether the labels or values are shown (e.g. in pop-ups) but I don't think it can be used in the append tool.

You may be able to fix it by applying the same domain to the destination field. If the tables are in the same geodatabase, they can use the same domain list, to help ensure the values are aligned.

https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/overview/create-modify-and-delete-do...

[DanielLane]

Yes, that was it!!!

Thankyou