Removing carriage return and spaces in a field

[ECEK]

I'm really struggling with this.
My import data is a list of categories. A, A1, B, C, C2, Cx for Example.

I have a reference table with additional data
A = True
A1 = False
B = True

etc

The problem is that if there is a space or carriage return in the import data I can't reference it from my table. So whilst the data says "B" it is in fact "Bcarriage return" and I cant reference it


I have this at present but I need to be able to remove carriage returns too.

 IIf(Len([Field1])>0,(Trim(Replace([Field1]," ",""))))

Your help is always appreciated.

 

[moke123]

have you tried replacing the various iterations for carriage returns?
ie.- vbCrLf, chr(10),chr(13), etc

 

[ECEK]

I found an answer to the carriage returns:

Replace(Replace(Nz([Field1],""),Chr(10),""),Chr(13),"")