Posts

Showing posts with the label CAT

Concatenation FUNCTIONS & CALL ROUTINES:

CATS/CATT/CATX Call Routines CAT/CATS/CATT/CATX Functions These Functions and Call Routines can be used to join two or more strings together. Even though we can use the concatenation operator in combination with the STRIP, TRIM, or LEFT functions, these functions make it much easier to put strings together and if you wish, to place one or more separator characters between the strings. One advantage of using the call routines than the functions is improved performance. Note: *Call routine executes faster than the function… in specific… CALL CATS: To concatenate two or more strings, removing both leading and trailing blanks. CATS () stands for concatenate and strip. Just think the ‘S’ at the end of the CATS as “Strip Blanks”. Syntax: CALL CATS (result, string-1<, string-n>); Example: A=”ABC’; B=” CONSULTING”; C=”INC “; D=” TEAM “; FUNCTION= RESULT CALL CATS(RESULT, A,B)= "ABCCONSULTING" CALL CATS(RESULT, A,B,C)= "ABCCONSULTINGINC" CALL CA...