I need help cleansing and sorting the the attached file (extract only). The following actions need to occur for my data to be cleansed:
1. Column A - remove all data after the first email address i.e. remove all data including the space after the email address leaving you with just a simple email address and not mention of SMTP etc
2. Column B,C,D - Extract Only First Name (where one exists) OR If there is not a first name and only Title + Surname THEN return Title + Surname in a single cell.
4. Column E - Select only those people in the list whose criteria in this column = 'DSA'
I am looking to create a comma separated file with the following syntax of all data in my list - with only those people whose 'category' = 'DSA':
email[separator]name[new line] etc etc
The objective is that my newsletter application imports all data and the is able to personalise all letters/newsletters
Dear David, (see syntax above) - assuming first name avalable
Dear Mr Scott, (see syntax above) - assuming no first name available