Text Parsing / Combining Fields / Help??? :)

[FruitFul]

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, 2005 by Guest

[Lee Smith]

Not sure if this is what you meant??

TextParsing.1.fp7.zip

[FruitFul]

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 :

[Lee Smith]

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, 2005 by Guest

[FruitFul]

Awesome! Thanks

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