inserting text

[glassmaster]

Hi -

I'm sure there's a simple answer to this but for the life of me I can't figure out this program. I'm new to databases generally and fm i particular.

I'm trying to export an fm text file. I need to add a tag to the beginning of each entry in each field before exporting so that I can upload to another program. So, for example, I would like to add "tag1 " (with a space) to the beginning of every entry in Field 1, then add "tag2 " to every entry in Field 2.

How do I do this -- using monosyllables if poss?!

Thank you!

FileMaker Version: 6

Platform: Windows 2000

[Fitch]

Create a calculated text field:

"tag1 " & field 1 & "tag2 " & field 2

Then export the calculated field rather than the original fields. Additional notes:

- Be sure the type of the calc field is set to text

- Literal strings of text go inside quote marks, field names do not

[Steve T.]

Hi, G! Do as Fitch says and use calc fields. Note Fitch used the "and sign (&)" to join them and not the plus sign (+) since they are strings.

one = "tag1" & " " & field1

two = "tag2" & " " & field2