Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.
Juggernaut

Leftwords function not properly working

Kitesurfer
in FileMaker Pro 18 Advanced

Featured Replies

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

Please provide a way to reproduce your problem. 

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.

  • Author
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.

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 by comment

  • 3 weeks later...
  • Author

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.

Create an account or sign in to comment

https://fmforums.com/topic/106979-leftwords-function-not-properly-working/
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.