The following combinations of “$f” can be used whenever you need to build a string (equivalent to Java’s java.util.Formatter).
Basics:
%[argument_index$][flags][width][.precision]conversion
Flags
Flag | Description |
’-‘ | left-justified |
’#’; ‘+’ | include sign |
’ ‘ | leading space |
‘0’ | zero-padded |
’,’ | separators |
’(‘ | enclose negative values |
Conversion
Conversion | Description |
b/B | boolean |
h/H | hash |
s/S | string |
”-“ | left justify |
c/C | character |
Sheet
Adding | Command | Results |
Time | $f(“Time: %1$tD %1t$tT”, new Date()) | “Time 05/30/22 01:02:03” |
Date | $f(“Date: %1$ty/%1$tm/%1$td %1$tH:%1$tM:%1$tS”, new Date()) | “Date: 22/05/30 01:02:03” |
Date full year | $f(“Year: %tY”, new Date()) | “2022” |
Number round | $f(“Decimals: %.2f %.2f”, 1.9, 1.999) | “decimals: 1.90 2.00” |
Number space pad | $f(“%10.2f”, 1.9) | (with 6 spaces) “1.90” |
Number left space pad | $f(“%-10.2f”, 1.9) | “1.90” (with 6 spaces) |
Number zero pad | $f(“%010.2f”, 1.9) | “0000001.90” |
Number sign | $f(“%+.2f %+.2f”, 1.9, -1.9) | “+1.90 -1.90” |
Number sign enclosure | $f(“%+.0f %(.0f”, 1, -1) | “+1 (1)” |
String space pad | $f(“%10s”, “hello”) | (with five spaces) “hello” |
String left space pad | $f(“%-10s”, “hello”) | “hello” (with five spaces) |
Boolean uppercase | $f(“%B %B”, true, false) | “TRUE FALSE” |