Concatenanting Strings

[Kashmira Parekh]

Hi Vikas, In this chapter 4, I have a couple of questions that I have highlighted on the word doc.  Can you please help me understand how we use the concatenating operators?

[Jennifer SUN]

HI Kashmira,

4.4.5 the answer is B and C. you can count forward and backward. also blank and comma are both dlm.

The CAT* functions concatenate character strings.

* CAT does not remove leading or trailing blanks, and does not
   insert separators.

 * CATT trims trailing blanks, but not leading blanks, and does not
   insert separators.

 * CATS strips both leading and trailing blanks, and does not
   insert separators.

 * CATX strips both leading and trailing blanks, and inserts
   separators. The first argument to CATX specifies the separator.

Function          Equivalent || code
------------------------------------

CAT(OF X1-X4)     X1||X2||X3||X4

CATT(OF X1-X4)    TRIM(X1)||TRIM(X2)||TRIM(X3)||TRIM(X4)

CATS(OF X1-X4)    TRIM(LEFT(X1))||TRIM(LEFT(X2))||TRIM(LEFT(X3))||
                  TRIM(LEFT(X4))

CATX(SP,OF X1-X4) TRIM(LEFT(X1))||SP||TRIM(LEFT(X2))||SP||
                  TRIM(LEFT(X3))||SP||TRIM(LEFT(X4))