best way to ...

[Joost Miltenburg]

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 ?

[beverly]

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.