Baylah Posted December 4, 2005 Share Posted December 4, 2005 This DB that I am working on requires that raw data from an excel spread sheet be imported to FMP. For some reason in a text field I call "machine" The Excel Cell has a "space" after the last charecter that carries into the import...so the import result = 114A (space) I have a seperate table that has machine properties based on machine number, like 114A. In the table in question I am doing a lookup to fill to fields based on the relationship between the identical machine numbers. The problem is, since Excle is putting this ******* space after the machine number, the look-ups won;t work. I know this is the problem, because if I manually enter the machine number, the look-up works properly. I have tried making my machine "name" in the related database to have a space at the end of the machine number, but that doesn't work. Any ideas how to fix this? I have tried limiting the number of charecter to 4 in the field, but that doesn't work. I'm really stumped. Steve Link to comment Share on other sites More sharing options...
Breezer Posted December 4, 2005 Share Posted December 4, 2005 Try using the trim function, for example: Trim (Machine) This will get rid of the extra spaces. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6712 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now