Oracle Hyperion Financial Management Tips And Techniques

Strings

A string is a series of characters enclosed by quotes. For example, “Tom Brady” is a string. What makes a string very helpful is that it can be broken up. For example, “Tom” and “Brady” are now two strings. When I add the ampersand (&), I can make the two strings tie back together. In this way, “Tom” & “Brady” is equal to “Tom Brady”.

Notice that I have a space in the “Tom Brady” string. That’s why my “Brady” started with a space. It might be glossed over when you read it, and is even harder to find in the scripting. For that reason, we would never use spaces when we can avoid them. In this case, we would use the underscore, “Tom_Brady”.

There is a whole toolset of functions that helps you bring these strings together. The following are ...