unother post manipulation

Some of you realy are fantastic. Im more like a userinterfaceperson. Please help me out
Recently I aske a question and got an excellent example from  lesouef. However I found that an_ is also calculated as a space. (at least in swedish character set) some emailadresses went wrong with the (usefirst 2 words as email-method)
Now the records look a little bit different. They look like this: Fieldsnames in the first raw.
Mailadress                            Group                      Country      Manufakturer      Sweden      Cunsultant                      Sweden      Enduser                      Sweden      Enduser                      Norway      Enduser                      Danmark      Enduser                      Finland      Manufakturer      Finland      Enduser                      Sweden      Cunsultant                      Sweden      Manufakturer      Sweden      Cunsultant                      Sweden

The target is to have one record and add the different info on groups and countries into the other field like:             Manufacturer Consultants Enuser         Sweden norway denmark           Manufacturer Consultants Enuser         Sweden finland

It is different amount of lines for everybody Many are just once and others can be many times but as I said the target is to keep info on one line.
It is not neccesary to remove the duplicates in this script. That could be done in another script afterwords if the lines are Identical.
Thanks a lot
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

I presume that you collect all the new records in a new table. add a global field where the script stores the email address (set field ...) . Then try to build a script with the following components:

1. store base info
sort your records by email address, go to the first record, store the email address of that record in the newly made global field.

2. find the relevant set of records
the script performs a search through the original set of records, searching for any record that has the email address you just stored in the global field.

3. add data to the new record
Make a loop through the current found set, and for every record add the content of the country field to the country field in the record you are building (the one in the new table)

4. find the next set of similar email addresses
At the end of the series of records, exit the loop, omit all records that have an email address similar to the one in the global field, go the the next record, and start over the script.

If you need real syntax, let me know.
you write you're a user interface man. So am I. Would you mind to share some of your work? You can send PDF if you prefer. I'll do the same.

good luck!

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
perbackmanAuthor Commented:
Hi, Thanks
I will try that this evening. What timezone are you in?
GMT+1 at the moment at least.
Introduction to Web Design

Develop a strong foundation and understanding of web design by learning HTML, CSS, and additional tools to help you develop your own website.

I'll review my previous example for this case if you don't like rogier's way, just let me know.
about the - and _ taken as word separators, this is true for all languages unfortunetaly.
what you can do as a work around, is replace all of them with a character which never exist in emails, like £ or µ, run the script and replace the other way around to restore the proper characters. not very smart, but the word separator is not programmable in fm. You can also avoid the word function and extract words using characters untill the first space encountered using the position function, but that makes it complex, though it can be done by purists!
perbackmanAuthor Commented:
Thank you both.
Filemaker gives you many ways to do things.
I made a selfrelation, added a portal with info from the related once  in the portal. Than I processed the duplicat posts by copying the lines in the portal to a singlefield in the mail table. Found out to make the looping through all duplicats.
OK It was some hands on. Had to find out the once wih 2 duplicats run the script, find out the once with 3 duplicats modify the script and so on. Bu I also found out about the variable scripting. This is a fine feature.
Guys, Thank you.
perbackmanAuthor Commented:
Some points to rogier
Thanks it gave me the ideas.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
FileMaker Pro

From novice to tech pro — start learning today.