Greetings,

I was talking with a teacher friend, and afterwards I was very curious about how to do the task below within Filemaker.

I have known it is used often for parsing text, but I have never delved into that aspect... Anyhow we were talking about different categories, and mixing/combining them.

So say you have Category A, B, and C. I have given them each their own table. Each one consists only of 1 field really, and each record set is just words.

Within the main Category (A) I have a text Field that I want to have combined text in. For example:

A+B

A+C

B+C

etc

(All within the same field, each having their own 'line')

I tried to script this to no avail (prefer script to calc field).

Every method I have thought to try simple results in zero '0'.

I attached the solution I was trying to test this all in.

TextParsing.zip

Edited August 13, 200520 yr by Guest

Not sure if this is what you meant??

TextParsing.1.fp7.zip

Kind of... At least nice to see it showing text in that field

With those ID's connected now - if I tried to script it would it work?

Have to go to a meeting - will play with it more when I get back :

Sure, just use the same calculation in your script as Insert Calculated Result, or Set Field. You will need to use a Loop Script Step if you want to do this in more than the current active record.

An example of a loop script is like:

Go to Record/Request/Page [ First ]

      Loop

      Set Field [ AText::text2; AText::A_Text & "¶" & BText:_Text & "¶" & CText::C_Text ]

      Go to Record/Request/Page [ Next; Exit after last ]

End Loop

HTH

Lee

Edited August 13, 200520 yr by Guest

Awesome! Thanks

Going to play around with it a bit over the weekend...