Retrieve String from a multi-line field

[antonisnyc]

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!