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.

best way to ...

Joost Miltenburg
in XML/XSL

Featured Replies

Hi,

I am having difficuties with import number and date field data. So, I read all data in text fields and parse them with a FM-field, but there should be a better method I think.

For instance, I get 200.25 in a xml field. However, in filemaker 200,25 is needed to correctly recognised as number, but using the same stylesheet in US should work correctly.

The same for a date field in xml. I get 20060616 this a date, but I need something like 16-06-2006, but in US this would be 06-16-2006.

How do I tackle these problems in general ?

I created a template (xsl:template) to format dates and another for numbers. You can revise as needed.

Pass the date field with:

The template:

In your case, use the function "substring()" which takes the parameters "string, start & length". This is similar to FileMaker's "Middle()" function.

Create an account or sign in to comment

https://fmforums.com/topic/44573-best-way-to/
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.