@MsgFormat

@MSGFORMAT takes a set of objects, formats them, and then inserts the formatted strings into the pattern at the appropriate places. (See the JAVA docs for "java.text.MessageFormat.)"

DTP Type:

@MSGFORMAT must be string.

Syntax:

@MSGFORMAT(text,param1,param2,param3,param4)

Parameters:

Parameter	Description
text	Design-time prompt string
param1	Design-time prompt
param2	Design-time prompt
param3	Design-time prompt
param4	Design-time prompt

Example:

[MSFG4]=@MSGFORMAT([String4],[FirsName],[LastName],[Month],[Year])

Where:

• [MSFG4] is DTP string that is not a checked prompt.

• [String4] is a promptable DTP string.

• [FirstName] is a promptable DTP string.

• [LastName] is a promptable DTP string.

• [Month] is a promptable DTP member with "Period" selected for the dimension.

• [Year] is a promptable DTP member with "Year" selected for the dimension

Assume that the following values are input:

• [String4]: "{0} {1} completed this task in {2} {3}"

• [FirstName]: "Joe"

• [LastName]: "Smith "

• [Month]: "Feb"

• [Year]: "FY15"

In this example, [MSFG4] returns "Joe Smith completed this task in Feb "FY15."