Remove Special Characters in KQL

Question

How can I remove [" and "] in KQL from the below column values?

["[email protected]"]  
["[email protected]"]  
["[email protected]"]

Thanks

Answer 1

I guess you would also like to remove the double quotes.

datatable(col:string)
[
     '["[email protected]"]'  
    ,'["[email protected]"]' 
    ,'["[email protected]"]'
]
| extend option_1 = trim(@'^\["|"]$', col)          // Trim opening [" and closing "]
| extend option_2 = trim(@'[[\]"]+', col)           // Trim sequences of the characters [, ] and "
| extend option_3 = extract(@'^\["(.*)"]$', 1, col) // Extract the expression between the opening [" and closing "]
| extend option_4 = tostring(todynamic(col)[0])     // Convert to json (resulting in json array) and retrieve the 1st element

col	option_1	option_2	option_3	option_4
["[email protected]"]	[email protected]	[email protected]	[email protected]	[email protected]
["[email protected]"]	[email protected]	[email protected]	[email protected]	[email protected]
["[email protected]"]	[email protected]	[email protected]	[email protected]	[email protected]

Fiddle