How do I parse a String using a formula or condition?  For example, if I want to do a comparison of the last three characters of a String, could I use [#Example String#].Right(3)=="-00"?  Is there a length function? Please provide the available functions.

Like 0

Like

1 comments

Dear Janine, 

You can perform all standard C# methods in formula (including all string operations). In your case you can use the following:

[#Example String#].Substring([#Example String#].Length - 3) == "-00"

or

[#Read data 1.First item of resulting collection.Full name#].EndsWith("-00")

Best regards,

Dennis

Show all comments