ConcatBlank (Concatenate Plus Blank Space)

The ConcatBlank function concatenates two or more input strings into one continuous string, inserting a blank space between each string. This function can be used to combine related values that are logically separated by spaces. For example, concatenating the two strings "Business" and "Intelligence" would result in the single string "Business Intelligence".

Syntax

ConcatBlank (Argument1, Argument2,..., ArgumentN)

Where:

Argument1,..., ArgumentN are facts, metrics, columns, or string values.

For information on the syntax used in your specific database, see MicroStrategy and Database Support for Functions and see the section that corresponds to your database.

Example

The ConcatBlank function can help to create attribute forms that are a combination of multiple columns in database tables. For example, an LU_CUSTOMER table includes two columns: CUST_FIRST_NAME and CUST_LAST_NAME. You can create a single attribute form that combines these two columns as described below.

ConcatBlank([CUST_FIRST_NAME], [CUST_LAST_NAME])

The input from the first column is concatenated with the input from the second column, and an additional space is included between the two inputs. This displays information such as John Doe and Jane Doe for the attribute form.

For an additional example of using the ConcatBlank function, see the example section for the function InitCap (Initial Capitalization).