format_string function
Applies to: 
Databricks SQL Databricks Runtime
Returns a formatted string from printf-style format strings.
The function exploits the java.util.Formatter class with Locale.US.
For details, see java.util.Formatter.
Syntax
format_string(strfmt [, obj1 [, ...] ])
Arguments
strfmt: ASTRINGexpression.objN:STRINGor numeric expressions.
Returns
A STRING.
Examples
SQL
> SELECT format_string('Hello World %d %s', 100, 'days');
Hello World 100 days