Trim special characters from string

Occasional Contributor

Issue: I got a Proofpoint TAP presenting logs with email recipient_s with unwanted characters as so [""] instead of
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.

| 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

0 Replies