Text Calculation and maybe a strong script

[George TOUBALIS]

I need a help please! (sorry for my bad english!!!!

I have 2 tables 1rst "Words" and 2nd Synonyms

In the first table I have The "Name of the word" field

I have and a second field named "Synonyms Source" where I can paste the Synonyms of the active word.

The source of synonyms (out of file maker where I copy theme) has the synonyms words in "comma delimited"

Example

The word "enter" has the synonyms

access, arrive, barge in, blow in, break in, breeze in, burst in, bust in, butt in, come, come in, crack, crawl, creep, crowd in, drive in, drop in, fall into, gain entree, get in, go in, horn in, immigrate, infiltrate, ingress, insert, insinuate, introduce, intrude, invade, jump in, make way, move in, pass into, penetrate, pierce, pile in, pop in, probe, rush in, slip, sneak, work in, worm in, wriggle

How can I move these words in the table "synonyms" In order.... one record per synonym and all these synonyms has father the word "enter" .?

Any one please....?

George

[comment]

I hope this is strong enough for you.

wordFactory.fp7.zip

[George TOUBALIS]

wow! thanx a lot !!!

Yes is strong and it's very fast too!

George

[comment]

Enjoy.

I have completely forgotten about this, and now that I look at it I notice a small mistake:

In script '@ create Synonyms', step 3, Calculated result, the correct definition of list should be:

list =

Substitute (

Words::Synonyms & [color:"red"] ", "[/color] ;

[

wordFactory.fp7.zip