Leftwords function not properly working

[Kitesurfer]

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

[comment]

Please provide a way to reproduce your problem. 

[rwoods]

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.

[Kitesurfer]

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.

[comment]

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

[Kitesurfer]

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.