Hi all,

I have 2 db they both have 1 text field. The first has strings of text for example

The solutions would be different according to which one of your fields would be at left side ?

Is this that you want to identify the "related match" from first to second db, or the contrary.

If you wanted to find all related matches from "6hoy" (Left side), a find would be all what you'd need IMO. Finding only the 2 or 3 characters would not be different I assume.

If you wanted to find all related matches from

Thanks for the reply,

I will try to clarify both db

You could do it with some calculated fields but whether it is worthwhile depends on the maximum length of the strings in db 1. If they don't get much longer than about 20 characters then you can do it with a calculated key field formula like:

Middle(TextField,1,3)&"

Sorry, I'd try to clarify too.

I'm not suggesting a loop through the related records. I'm rather proposing a loop that would set the current record as a Multi-Line key, suitable for a relationship.

I assumed this wouldn't be a calculated field but rather a global field.

The Precision number I suggested was also designed to give you this "match latitude" that you requested.

Let try to map it out a little. I didn't tried it though...

t_Field

g_FieldParsed

g_Precision

g_counter

g_Mkey

SetField[g_counter,0]

SetField[g_FieldParsed, t_Field]

Loop

endLoopIf[g_counter = Lenght(g_FieldParsed)-g_Precision]

SetField[g_counter,g_counter+1]

SetField[g_Mkey, g_Mkey&"

So now he has 2 options

There was in fact on little correction for my script.

EndLoopIf[g_counter = Lenght(g_parsed)-g_precision+1]

And I changed the Multiline key to text instead of a global.

See atttached.

parsing.fp5.zip

Thanks for the help. I'll give these a try.