Jump to content

text import


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

Recommended Posts

I have imported emails from outlook which contain web form replies in the following format.

------------------------------------

Contact_FirstName: FName

Contact_LastName: LName

Contact_Title: Mr

Contact_Organization: Filemaker Inc

Contact_StreetAddress: PO Box 123

Contact_Address2: AppleLand

Contact_City: Applesville

Contact_County:

Contact_PostCode: AP2222

-------------------------------------

How can I split this up in to the appropriate fields that are needed for this?

Any help would be appreciated

Thanks

Simon

FileMaker Version: Dev 6

Platform: Windows XP

Link to comment
Share on other sites

A couple of different ways. How about this one:

- import these "records" into a temporary fm file

- then loop through the records and use the LeftWords function to read the data and do a Set Field to the correct field in your main contacts fm file

Another approach is to do some pre-processing to the Outlook file by replacing the returns by spaces and then importing into filemaker.

Link to comment
Share on other sites

Hi Simon,

Wim has two good suggestions, here is a third.

Provided that the following is true.

The dash lines were there for our benefit and isn't part of the export from OE.

The Number of fields are always the same With or Without data, the field names are there (as per your example).

Then you could run the data through a Text Editor and Find/Replace the Field names with Tabs, Except for Contact_FirstName:, which you would just delete, and then import the text into your FileMaker file.

HTH

Lee

FileMaker Version: 6

Platform: Mac OS 9

Link to comment
Share on other sites

This topic is 6496 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.