Hi NG,

i am locking for a plugin or something to import an Order (Text Mail)
from ShareIt into my filemaker 8.51 database. I there a way to do
this?

Thx for any Help

Ulrike

If all you're doing is importing text, FileMaker is quite capable of doing that on it its own, not plugin necessary.

You would likely import the entire text into one field, then parse it out to separate fields using various text functions.

Matt

On 02/20/2007 08:21:23 "CB" <info (AT) gaeb-online (DOT) de> wrote:

Hi,

I want to parse several text fields into separate database fields. Can
you tell me where to find an example for the text functions you
mentioned? Do I have to put this in a script? Sorry for these "newbee"
questions...

Ulrike

The text i´ll copy from the eMail looks like this, the delimiter will
be the =

Vorname = Name
Nachname = Name1
Firma = Company
Strasse = Street
PLZ = 12345
Stadt = City
PLZ + Stadt = 12345 City
Land = Germnay
Staat / Provinz =
Telefon = 0789 12345
Fax = 0789 45678

Hi there, me again,

has really no one a idea how to find the text after the delimiter and
copy it into a field of the database?

Firma = Company

The script should find the text after the = (here Company)

If you can be sure it will always be in this format, then you can use Position and Middle functions for pretty much all of it.

Quick example:

We'll put your text into a field named Import, and extract the Telefon number:

Telefon =

Let (

Pos = Position ( Import ; "Telefon" ; 1 ; 1 ) + 10 ;

Middle ( Import ; Pos ; 10 ) )

In plain words, the Let function establishes the position of the Telefon number in the text relative to the word "Telefon"; the number starts ten characters after the word.

The telefon number is ten characters, including the space; the Middle function extracts ten characters, starting at the location of the previously determined variable Pos.

You can do this either a a calculation field, or script it using the Set Field step.

For other examples, look at text functions in Help.

Matt



On 02/20/2007 11:06:55 "CB" <info (AT) gaeb-online (DOT) de> wrote:

Thanks Matt - it works fine

Ulrike

I just need someone to help me understand something:

Filemaker 8.51? is that for Windows or MAC? I haven't seen any updates for
8.5 yet, unless I'm not looking in the right place.

Unless he was referring to FM 8.5v1 ?

Thanks,

-Amazing Iceman

"CB" <info (AT) gaeb-online (DOT) de> wrote