Emerson Exchange 365

• Not Answered

Is there a way to determine if a string contains a specific character?

I am pulling in a string of text and I want to be able to determine the number of characters in the string, as well as if the string contains specific characters (like "@").  Is there a way to do this?

rummeln

• 5 May 2017 8:06 PM
• Cancel

1 Reply

• Andre Dicaire

  

  • 5 May 2017 8:32 PM

  Depends where you are doing this.
  
  In the controller, the expression functions for strings are limited and not intended for elaborate string manipulation. BOL discusses examples such as concatenation, conversion and assignment. There are several specific time related string functions and the Select String function. That is about it.
  
  If you bring this up to the Operator station, you can use a VBA function to parse the string and find characters, string length, character position, etc.

  Andre Dicaire

  • Cancel