I have a large email list I broadcast to, where each subscriber has multiple tags. My email broadcast system lets me download each tag as a separate CSV file containing all tagged email addresses* and not containing those without the tag.
I need to combine these tags in complex ways, so that I can essentially create a new set of tags to upload back to the site, as a new CSV file to be imported.
The software would either work off the original CSV files themselves (which would be less work for me) or off a resulting file I'd create by combining all of them into a CSV file with emails as the first column and tags as all other columns, with some Boolean 1/0 or yes/no etc.
This wouldn't be a once-off, so having a system in place to do these processes often is necessary.
Parsing the data to create a new file
I'd like to take the data (whether it be in from separate one-column CSV files, or simply from the resulting new single CSV file with multiple columns) and compare the yes/no combinations of the tags for each email and based on combinations (see below), decide whether or not that email is included or ignored.
This could be a simple case of adding a new 0 or 1 column to the same "grand" CSV file (which I could then add the extra step of filtering only '1's to the final CSV file) or adding/not adding that email itself to the final CSV file.
Complex operations needed
Here is a sample of the kind of processes I would need to run:
- all of (tag1, tag7, tag8) and NOT (tag2, tag20)
- at least 2 out of any from (tag11, tag12, tag13, tag14, tag15, tag16, tag17, tag18)
- (if tag17 is present, AND any out of (tag22, tag23, tag24)) OR (if tag18 is present, AND any out of (tag25, tag26, tag27))
- only tag24, and NOT any other tag
- only tag24, and NOT any out of (tag 11, tag12, tag13, tag14)
From some research online, I can see that the solution to my problem most likely involves writing up the code in python or similar, but I'm hoping there is a user-friendly software application that can do it so I can achieve what I'd like without coding.
If coding is required, it would ideally be kept to a minimum, or I'd have a script ready to go that I'd only need to alter file-sources & the if requests. I'm comfortable with writing if structures. Otherwise, I have basic coding experience and can learn what I need to do in that software environment.
I own Excel 2017 (maybe there is a plug-in I'm not aware of for my complex filters) and can pay for software to do this if needed, depending on its functionality, although features beyond what I've described here aren't necessary.
Thanks for any recommendations!!
*The downloaded CSV file also has their name in another column, but I'd remove that for the purposes of this process.