String functions

PowerSuite scripting implements several functions to allow for string manipulation, similar to Microsoft SQL language string functions.

•      LEFT  https://learn.microsoft.com/en-us/sql/t-sql/functions/left-transact-sql

•      RIGHT https://learn.microsoft.com/en-us/sql/t-sql/functions/right-transact-sql

•      LEN   https://learn.microsoft.com/en-us/sql/t-sql/functions/len-transact-sql

•      CHARINDEX  https://learn.microsoft.com/en-us/sql/t-sql/functions/charindex-transact-sql

•      SUBSTRING  https://learn.microsoft.com/en-us/sql/t-sql/functions/substring-transact-sql

•      LOWER https://learn.microsoft.com/en-us/sql/t-sql/functions/lower-transact-sql

•      UPPER https://learn.microsoft.com/en-us/sql/t-sql/functions/upper-transact-sql

The following example demonstrates the use of string functions.

CASE

          WHEN len([City]) = 3 THEN 'three'

          WHEN lower([Continent]) = 'au' THEN 'Australia'

          WHEN upper([Country]) = 'US' THEN 'Us'

          WHEN charindex('n', [UserName]) > 2 THEN 'Department1'

          WHEN substring([Department], 5, 2) = 'FN' THEN 'Finance'

          WHEN left([Country], 4) = 'Germ' THEN 'Germany'

          ELSE 'Unknown'

END