Amount in Words in Rabic
Hello All;
Is it possible to make the function of “Amount in words” to be in Arabic
this one
“CASE WHEN {total}=0 THEN ‘ZERO’ ELSE TO_CHAR(TO_TIMESTAMP(LPAD(TRUNC({total}, 0), 9, ‘0’), ‘FF9’ ), ‘FFSP’) || (CASE WHEN {total}-TRUNC({total}, 0) > 0 THEN ‘ AND ‘ || (CASE WHEN LENGTH(TO_CHAR(REGEXP_REPLACE({total}, ‘^[0-9]+\.’, ”))) = 1 THEN TO_CHAR(REGEXP_REPLACE({total}, ‘^[0-9]+\.’, ”)) || ‘0/100’ ELSE (TO_CHAR(REGEXP_REPLACE({total}, ‘^[0-9]+\.’, ”)) || ‘/100’) END) ELSE ” END) || ‘ ONLY ‘ END”
Thanks