Problem
GlobalCapture can perform addition and subtraction functions on numeric process fields. This functionality can be useful when working though lists or tables of data. It's important to understand when and how GlobalCapture will perform math functions on data, and how data in a field will be processed to ensure expected results.
Solution
The presence of a "+" or a "-" in the Value of a Set Process Field node will only operate as a mathematical function if the data type of the field is correct. When using a character field, these characters will be treated as literal values versus an expression.
NOTE: When using notation, the data type of the process fields in the notation will impact the entire expression. If for example you use a notation like
The way notations work, there is a hierarchy created with our datatypes. Date, Dec, Num, then Char. As soon as one of these type of fields is used, the Math Mode get changed and held at the highest tier. In this case Dan is using a numeric type as the index of a MV, so {p_MVChar[p_NumIndex]} That MVChar contains data such as "123-456". Because the math mode has been changed to numeric, it's going to try to do math with that output. So alternatively, Dan can set the {p_NumIndex} to a char then use that char as {p_MVChar[p_CharIndex]} and it should resolve the issue.
Related articles