Kitesurfer Posted September 8, 2020 Share Posted September 8, 2020 Hi, Can someone please explain why Leftwords function is not properly working when importing an excell sheet. For example the name John Doe LeftWords ( Client ; 1 ) should show "John" only. When typing John Doe it works fine but not when importing ???? Looking forward to a reply. Kind regards Rudy Link to comment Share on other sites More sharing options...
comment Posted September 8, 2020 Share Posted September 8, 2020 Please provide a way to reproduce your problem. Link to comment Share on other sites More sharing options...
rwoods Posted September 8, 2020 Share Posted September 8, 2020 I expect the content of your Excel file is unusual. Perhaps the space character between John and Doe is not a normal space, but something else that FM doesn't recognise. Link to comment Share on other sites More sharing options...
Kitesurfer Posted September 9, 2020 Author Share Posted September 9, 2020 17 hours ago, comment said: Please provide a way to reproduce your problem. Hi, it's due to the excell sheet, the space in between John and Doe is indeed not recognized as a blank space. Thank you fro trying to help me. 16 hours ago, rwoods said: I expect the content of your Excel file is unusual. Perhaps the space character between John and Doe is not a normal space, but something else that FM doesn't recognise. Hi, it's due to the excell sheet, the space in between John and Doe is indeed not recognized as a blank space. Thank you fro trying to help me. Link to comment Share on other sites More sharing options...
comment Posted September 9, 2020 Share Posted September 9, 2020 (edited) 4 hours ago, Kitesurfer said: the space in between John and Doe is indeed not recognized as a blank space. That does not help us help you. Can you post an example of the Excel source (make sure it does not contain sensitive information). -- P.S. Please update your profile to reflect your version and OS so we know what you can use. Edited September 9, 2020 by comment Link to comment Share on other sites More sharing options...
Kitesurfer Posted October 1, 2020 Author Share Posted October 1, 2020 Thank you for your reply, but Filemaker is not to blame here it is the excel document. Many thanks again for wanting to help me. Have updated my profile also. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 969 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