逆引きFormula に戻る

しーさんからのお題です。早速やってみましょう。

https://twitter.com/Sealabo19/status/1695226068951863496

1. 最も簡単なのは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,")
   

2. 長さを3の倍数にして replaceAll を使うこともできます。

   replace(replace(replaceAll(slice("000" + format(prop("数値")), length(format(prop("数値"))) % 3), "(\\\\d{3})", "$1,"), "^0+,?", "¥"), ",$", "")
   

無題