Filemaker guru wanted!

Primary tabs

4 posts / 0 new
Last post
Jared Benson's picture
Online
Joined: 25 Apr 2005 - 6:41pm
Filemaker guru wanted!
0

What filemaker gurus do we have here? Does anyone want to help us streamline our Typophile back-end database?

I need to know how to use Filemaker to parse text out of one field into multiple fields, as shown:

A field containing:

1. Jared Benson
2. benson@typophile.com
3. Hello

Would parse into: (field names are shown in bracketts)

[Firstname] Jared
[Lastname] Benson
[Email] benson@typophile.com
[Quote] hello

It would seem that there’d be a way to select text between “1.” and “2.” and then use the Copy/Paste scripts to paste into the appropriate field.

Any help?

Jean F Porchez's picture
Offline
Joined: 7 Jan 2003 - 11:00am
0

To my limited knowledge, not possible, but via some apple scripts, export to txt, delete the 1. 2. 3., change tthem tab, then re-import, something like that.

Clive Bruton from FontZone is the right guy for any FM stuff, he manage FZ with FM.

Matha Stand�n's picture
Offline
Joined: 18 Jan 2003 - 5:13am
0

Clive Bruton?

Not ‘CB’, the semi-anonymous werewolf?

I thought he was just a legend.
Those medieval shepherdesses didn’t die for nothing after all.

M

Anonymous's picture
Offline
Joined: 6 Mar 2002 - 1:06pm
0

It’s pretty tricky, especially if all the entry isn’t there as you have it, ie it goes:

1 Jared
2 Benson@...
3 hello

or

1 jared
3 hello

or if it’s in a different order.

I would personally go down the route of creating a calc field, trying to delimit that data appropriately, then export it and import to a new database — perhaps use a relationship/lookup to populate fields in the old database.

FM’s text processing is pretty poor, so don’t bother yourself trying to script it to parse text.

You could try it via AppleScript, but I think the calc method would be better.

Topic locked