-1

I have the following query which provides me with all the data I need exported but I would like text '
' removed from my final query. How would I achieve this?

| where type == "microsoft.security/assessments"
| project id = tostring(id),
          Vulnerabilities = properties.metadata.description,
          Severity = properties.metadata.severity,
          Remediations = properties.metadata.remediationDescription
| parse kind=regex id with '/virtualMachines/' Name '/providers/'
| where isnotempty(Name)
| project Name, Severity, Vulnerabilities,  Remediations ```
David דודו Markovitz
  • 42,900
  • 6
  • 64
  • 88
dehgrah101
  • 1
  • 1

1 Answers1

0

You could use replace_string() (https://learn.microsoft.com/en-us/azure/data-explorer/kusto/query/replace-string-function) to replace any substring with an empty string

Yoni L.
  • 22,627
  • 2
  • 29
  • 48
  • How would I incorporate that into my script like this if I wanted to replace '
    ' with 'Next'? ``` | extend replaced=replace_regex(str, @'
    (\d+)', @'Next') ```     – dehgrah101 Oct 29 '22 at 20:36