Jump to content

antonisnyc

Members
  • Posts

    1
  • Joined

  • Last visited

antonisnyc's Achievements

Newbie

Newbie (1/7)

0

Reputation

  1. 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!
×
×
  • Create New...