perbackman
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
ASKER
Thanks
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
reload the file to get it.
it a separate script "re-order" but could added to the "clean" one
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