Jump to content

Retrieve String from a multi-line field


antonisnyc

Recommended Posts

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

image.thumb.png.f3e57214eb2e774220d6b57e84ca14c2.png

 

Thanks a lot in advance!

 

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...