Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Method for post manupulation. Might be tricky

Posted on 2006-04-04
Medium Priority
Last Modified: 2010-04-27
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
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
Question by:perbackman
  • 4
LVL 28

Expert Comment

ID: 16377353
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
LVL 28

Accepted Solution

lesouef earned 1000 total points
ID: 16379496
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
LVL 28

Expert Comment

ID: 16389768
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

Author Comment

ID: 16389807
LVL 28

Expert Comment

ID: 16389909
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

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
Integration Management Part 2
Screencast - Getting to Know the Pipeline
Suggested Courses
Course of the Month13 days, 23 hours left to enroll

581 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question