SPRINTF

Description

Uses printf-style template to formats a set of values using the native Java formatter library.

Syntax

SPRINTF(format_expression[, val1] [, valN])

Arguments

  format_expression - string expression that evaluates to a printf-style template

  val1 ... valN - Values to place in the template. Their data type must match the formatting argument category. Note that datetime values are not supported - use ToString to format a datetime expression.

Examples


SPRINTF('%d is a %s',50,'number') returns '50 is a number'.

Return value datatype

String

Impact of null value

If any input is null, returns null.

Feedback and Knowledge Base