I am using the new method: Utilities.formatString()

In the Google Documentation is says it is similar to sprintf %-style.

I searched and read this article about sprintf in PHP.

I cannot seem to get this to work as intended. It is meant to pad this 8 character string with 4 leading zeros. I know there are other ways to do this, But I am trying to get a handle on this sprintf / formatString thing.

var noFormat = "12345678";
var formatted = Utilities.formatString("%012s", noFormat);

I expected the var formatted to be equal to "000012345678". my debugger tell me that formatted = 0, or sometimes it throws an error..

I am confused.

I am using the new method: Utilities.formatString()

In the Google Documentation is says it is similar to sprintf %-style.

I searched and read this article about sprintf in PHP.

I cannot seem to get this to work as intended. It is meant to pad this 8 character string with 4 leading zeros. I know there are other ways to do this, But I am trying to get a handle on this sprintf / formatString thing.

var noFormat = "12345678";
var formatted = Utilities.formatString("%012s", noFormat);

I expected the var formatted to be equal to "000012345678". my debugger tell me that formatted = 0, or sometimes it throws an error..

I am confused.

• javascript
• google-apps-script

Share Improve this question Follow asked Mar 26, 2013 at 0:29 Duder-onomyDuder-onomy 9511 gold badge11 silver badge33 bronze badges

Add a ment  | 

1 Answer 1

Sorted by: Reset to default 10

try it like this :

function xxx(){
  var noFormat = '12345678'
  var formatted = Utilities.formatString("%012d", noFormat);
Logger.log(formatted)
}

the different parameters that can be used are easy to find on the web, here is an example that explains how the argument must be evaluated in php but the usage is the same.

Logger result :