Method for post manupulation. Might be tricky

Hi, Nedd help I guess.
I have a teble with emailadresses. All the adresses can be more than once (which is bad). There is also a field for when he/she is supposed to get mail.
So Field Emailadress + field info
Ex:
1 post = me@here.com, mondays tusedays
2 post = me@here.com, mondays wensdays
3 post = me@here.com, sundays
4 post = me@here.com, mondays tusedays

Now I would of course need the daynames in one post and then remove the leftovers so I have the emailadress only once. If I could add all the names in all the posts I could easily remove the duplicates by sorting a summarised fileld and update them as firs second third and so on. The pb is to add all the values together I guess.
There is 7000 posts so its is hard to do it manually.

PLS How would you do that the best way?
Regards Per Bäckman
perbackmanAsked:
Who is Participating?
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.

lesouefCommented:
It's late for me, I'll deal with that too-morrow.
The idea is to:
- detect duplicates
- for each set of dups, loop through records and check word 2 till nb of words -1, if it exist in the previous record using variables to store temp values. if it does not, add the word to the post.
may not be clear now, but I'll tell you more too-morrow if needed
0
lesouefCommented:
http://www.lesouef.net/files/clean_mail.fp7
in fact I just did a loop which compares the current content with the previous one, etc...
let me know if some parts of the script are not clear.
to make it look perfect, you could write another script to re-order days within the field
0

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
lesouefCommented:
thanks
juts a little note to understand the "post" splitting method: '@' is taken as a word separator by fm, so the email is the 1st 2 words, not 1
0
perbackmanAuthor Commented:
Thanks
0
lesouefCommented:
and I've done the days sorting stuff as well
reload the file to get it.
it a separate script "re-order" but could added to the "clean" one
0
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.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.