importing html-file or right excel-dates

[LasseJ]

I have to import a html-file on a daily basis. As it doesnt seem to be possible to import a html-file I open the file through Excel and import the data that way. A bit long-winded, but it works..

Heres my problem: Renaming the HTML-file to excel takes away the first digit in a datefield, if the number is zero( 010207 becomes 10207)

Is there anyway I can force FM to read a five digit number as a date - Or have I done everything wrong in the first place : ?

Regards

Lasse

Edited February 19, 2007 by Guest

[Søren Dyhr]

Hi Lasse

If a calc'field is set to date format as result, could this do it:

Let(theNorm=Right(0 & input;6);Date ( Middle ( theNorm ; 3;2 ) ; Left ( theNorm ; 2 ) ; "20"& Right(theNorm;2) ))

Provided the dateformat follows north european nomenclature, if the format follows say Japaneese or american, a slight reshufling of the Middle(, Left( and Right('s are required.

--sd

[LasseJ]

Hi Søren

A quick and good answer!

Once again you helped me out. Thank you very much.

Regards

Lasse

[Søren Dyhr]

But every one in your shoes, might drift thier approaches this way???

http://www.filemakermagazine.com/secured/648/AutomaticTextExtraction_full.mov

--sd