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
1 comments
06:23 May 20, 2019
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