I have a text field in a table with a blank space at the end of every record. The data before the blank varies in length. I need to join two tables using thus field. How can I remove this blank space?
The file is like this for what looks like all the text fields (some are numeric and date and look OK). Can I remove thus space in all the fields at once?