逆引きFormula に戻る
しーさんからのお題です。早速やってみましょう。
- 最も簡単なのはreplace を再帰的に使うことで下から,を埋めていく感じです。
"¥" + replace(replace(replace(replace(replace(replace(format(prop("数値")), "(\\d)(\\d{3})$", "$1,$2"), "(\\d)(\\d{3}),", "$1,$2,"), "(\\d)(\\d{3}),", "$1,$2,"), "(\\d)(\\d{3}),", "$1,$2,"), "(\\d)(\\d{3}),", "$1,$2,"), "(\\d)(\\d{3}),", "$1,$2,")
- 長さを3の倍数にして replaceAll を使うこともできます。
replace(replace(replaceAll(slice("000" + format(prop("数値")), length(format(prop("数値"))) % 3), "(\\d{3})", "$1,"), "^0+,?", "¥"), ",$", "")
名前
数値
金額表示(replace複数回)
金額表示(長さを調整)