I have a 2 column CSV file of sender and receiver email addresses. The 2nd column contains between 1 and 20 receiver email addresses.
In this example 'S1' = sender email address and 'R1', 'R2', 'R3' etc. = receiver email addresses.
I need to export or convert the file so that is contains only single sender and receiver pairs.
The input data is as follows (each line):
'S1','R1,R2,R3'
The output required for each line of input is:
'S1','R1'
'S1','R2'
'S1','R3'
Please note the actual data has double quotes not single quotes as above (the website is not displaying double quotes correctly)
Please note that extra lines are added to 'de-flatten' the multiple receivers in column 2 with the Sender being copied to these new lines.
I don't mind what language is used to do this e.g. VB, Perl, Python etc. but it needs to be as simple as possible so that it can be easily modified or used with different input data
Budget is approximately $15 or more for a really elegant solution :)
I can supply some sample data if required
Many thanks