I have a csv file like :
User_id,emails
375352,foo@foo.com foo@foo.ca foobar@foobar.co.uk
872352,toto@foo.com
note: email addresses are blank separated within the csv file
On the other hand I have an email log file in which I have fields such as x_recipients, x_sender that contain email addresses
What I would like to achieve is a search based on the User_id that will show all emails sent or received. What i have done so far is a lookup that matches my event field x_recipient with my csv field emails to output the User_id. It works but only for csv entries where emails has only one value (toto@foo.com in my example).
Any idea why I have this behaviour ?
Many thanks
Laurent
... View more