G
Guest
Access 2003 on Windows XP machine:
I've imported some data from a text file. The EEName field is 30 characters
long, and the data that was brought in is padded with spaces.
To trim the extra spaces off, I added a new field, and ran an Update Query,
to update the NewField to TRIM([EEName]).
NewField is still padded with spaces - exactly the same as the original
EEName.
I can copy the value of an EEName field, and copy it as a literal into the
command window with the command:
?trim("LAST, FIRSTNAME ")
and I will get the trimmed name as a result, so I know the TRIM function
works in my Access install.
It wasn't really necessary, since the TRIM function worked in the Command
Window, but I tested the last character of the EEName field, and the ASCII
value is 32, so I know it is a space.
I'm stymied.
Any suggestions?
I've imported some data from a text file. The EEName field is 30 characters
long, and the data that was brought in is padded with spaces.
To trim the extra spaces off, I added a new field, and ran an Update Query,
to update the NewField to TRIM([EEName]).
NewField is still padded with spaces - exactly the same as the original
EEName.
I can copy the value of an EEName field, and copy it as a literal into the
command window with the command:
?trim("LAST, FIRSTNAME ")
and I will get the trimmed name as a result, so I know the TRIM function
works in my Access install.
It wasn't really necessary, since the TRIM function worked in the Command
Window, but I tested the last character of the EEName field, and the ASCII
value is 32, so I know it is a space.
I'm stymied.
Any suggestions?