Jump to content
The ORIGINAL FileMaker Community - Forum - Online Business Apps & Software Forum

Read line

Recommended Posts


I have a text  file which I would like to import into my database. 

There are may lines which are either blank or have information which have no relevance to my database.

Does Filemaker have a command to open this text file then read each line and the based on my formula write this information into my database. 


Share this post

Link to post
Share on other sites
Steve Martino

This happens to me when importing an excel File.  In my case the excel files have account numbers for the records I want to import, and blank fields in account numbers for 'records' I don't want.

What works for me is to import to a utility layout.  A simple script that does an import, does an Omit Find for the records I don't need (blank account number field), delete all, then move the remaining good records to the proper table.  Checking of course along the way for errors.

Share this post

Link to post
Share on other sites
This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...

Important Information

Terms of Use