Extract information between Characters

[NavMen]

Hi,

I’m trying to extract some information from a stored message in the SQL database, the message looks like:

Info –I : Message Text [windows event xxx]

I like to extract the information between the “:” and “[“ the query I created is as follows:

Select substring(message,9,500) as 'Message' from SysMessage

It works well if the info before the “:” is 9 characters, I don’t know how to fix this problem. The Message Text is variable in size.

All help is welcome.

Thanks,

J

 

[Pattycake245]

Can't test this, but something like this should be close

select substring(ltrim(rtrim(message)),charindex(':',message)-1,right(charindex('[',message))
from table

You can play around with it anyway to get your desired result

Tim