I am trying to retrieve the highlighted value shown in the picture below. I used sub-string as seen below to create a new column called Account_Name, but because the Account name exists twice it only picks up the first one and not the one i would like. Do you know what i should change?
Retrieve String from a multi-line field
in SQL
Posted
Hello,
I am trying to retrieve the highlighted value shown in the picture below. I used sub-string as seen below to create a new column called Account_Name, but because the Account name exists twice it only picks up the first one and not the one i would like. Do you know what i should change?
SubString(Reverse(tblNtlogMessage.Message), Len(Right(tblNtlogMessage.Message,
CharIndex('Account Name:', tblNtlogMessage.Message))) + 13,
Len(tblNtlogMessage.Message) - Len(Right(tblNtlogMessage.Message,
CharIndex('Account Name:', tblNtlogMessage.Message))) -
Len(Right(tblNtlogMessage.Message, Len(tblNtlogMessage.Message) -
CharIndex('Account Domain:', tblNtlogMessage.Message))) - 15) Account_Name
Thanks a lot in advance!