Jump to content

antonisnyc

Members
  • Content Count

    1
  • Joined

  • Last visited

Community Reputation

0 Neutral

About antonisnyc

  • Rank
    Newbie
  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...