イシュー
- 以下のサイトの実装を数式で行ったら「構文エラー。余分な'.'」エラーになった
- 数式:REGEXによる通貨フォーマット変換を試してみる
参考
結局
CASE( LEN(TEXT(ROUND(Price__c,0))),
1, MID(TEXT(Price__c),1,1),
2, MID(TEXT(Price__c),1,2),
3, MID(TEXT(Price__c),1,3),
4, MID(TEXT(Price__c), 1, 1) & "," & MID(TEXT(Price__c),2,3),
5, MID(TEXT(Price__c), 1, 2) & "," & MID(TEXT(Price__c),3,3),
6, MID(TEXT(Price__c), 1, 3) & "," & MID(TEXT(Price__c),4,3),
7, MID(TEXT(Price__c), 1, 1) & "," & MID(TEXT(Price__c), 2, 3) & "," & MID(TEXT(Price__c),5,3),
8, MID(TEXT(Price__c), 1, 2) & "," & MID(TEXT(Price__c), 3, 3) & "," & MID(TEXT(Price__c),6,3),
9, MID(TEXT(Price__c), 1, 3) & "," & MID(TEXT(Price__c), 4, 3) & "," & MID(TEXT(Price__c),7,3),
"ng"
)
ちょっと最適化した
MID(TEXT(Price__c),1,LEN(TEXT(FLOOR(Price__c)))-(FLOOR((LEN(TEXT(FLOOR(Price__c)))-1)/3)*3)) &
IF(LEN(TEXT(FLOOR(Price__c)))>3,
"," & MID(TEXT(Price__c),LEN(TEXT(FLOOR(Price__c)))-(FLOOR((LEN(TEXT(FLOOR(Price__c)))-1)/3)*3-1),3),
""
) &
IF(LEN(TEXT(FLOOR(Price__c)))>6,
"," & MID(TEXT(Price__c),LEN(TEXT(FLOOR(Price__c)))-(FLOOR((LEN(TEXT(FLOOR(Price__c)))-1)/3)*3-4),3),
""
)