Issue: I got a Proofpoint TAP presenting logs with email recipient_s with unwanted characters as so ["samuel.banahene@hotmail.com"] instead of samuel.banahene@hotmail.com.
In trying to remove the []," characters, I was only able to use the trim function to remove the ] at the end, with the syntax below.
ProofPointTAPMessagesDelivered_CL
| extend Recipient = trim(@"]", recipient_s)
| project Recipient
when I changed the ] to [ to get rid of the leading character, I got an error:
trim(): argument #1 must be a string literal evaluating to a valid regular expression
I guess the simplest question is how would I remove the unwanted characters from a dynamic array of (["recipient_s"]) to get recipients_s ?
Your help is very much appreciated
