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.

importing html-file or right excel-dates

LasseJ
in Importing & Exporting

Featured Replies

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

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

  • Author

Hi Søren

A quick and good answer!

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

Regards

Lasse

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

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

--sd

Create an account or sign in to comment

https://fmforums.com/topic/50059-importing-html-file-or-right-excel-dates/
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.