I’m working in Kusto Query Language and I would like to display not everything from the selected string.
My string is ‘Execution fail against sql server. Please contact SQL Server team if you need further support. Sql error number: 50000. Error Message: Invalid length parameter passed to the LEFT or
SUBSTRING function.’
But I would like to just display from ‘Error Message: Invalid length parameter passed to the LEFT or
SUBSTRING function.’
Could anybody help me with this problem? I don’t know which function I need to use in KQL.
Thanks!
An answer on my question 😉
2
Answers
you could use the
parse
operator. for example:Fiddle
If needed, concatenate "Error Message:" to the start of the message