Method for post manupulation. Might be tricky

Posted on 2006-04-04
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 =, mondays tusedays
2 post =, mondays wensdays
3 post =, sundays
4 post =, 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
    LVL 28

    Expert Comment

    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

    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

    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

    LVL 28

    Expert Comment

    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

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Suggested Solutions

    Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
    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…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    730 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

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now