Copying the first few characters from a field

[hello_uk]

Hi. Newbie to the forums here... I have a database where I have two fields of data - let's call them field A and field B, and what I'd like to do is get Filemaker to automatically copy just the first 5 characters of field A and paste them to the start of the data in field B.

E.g. Field A currently says '1234abcd' and field B says 'efgh' and what I want is for Filemaker to add the '1234' part to field B, so that it ends up saying

1234efgh

Does anyone know how I do this? TIA!

[dreamingmind]

left(A;5) will return you the first 5 characters of A

So, you can concatenate them to the beginning of B like this:

left (A;5) & B

In a script you would use the SetField step. Or, you could do this as an auto entered calculation, but I'm guessing you're working in a script.

Regards,

Don

Edited September 28, 2008 by Guest