Jump to content

importing html-file or right excel-dates


LasseJ
 Share

This topic is 5705 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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 by Guest
Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 5705 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

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