How to set space in numbers

Question

Question

Token Ibragimov · Apr 2, 2018

Hello!

Is it possible in cache to divide numbers with spaces. For example number 12500 divide to 12 500?

Thank you!

Discussion (5)0

Log in or sign up to continue

Dmitry Maslennikov · Apr 2, 2018

set groupSeparator=##class(%SYS.NLS.Format).SetFormatItem("NumericGroupSeparator"," ")
write $fnumber(12345.678, ",", 2)
12 345.68

By default in english locale group separator is comma

3 0

score 0 · Answer 1 · 2018-04-02T05:35:12-04:00

Token Ibragimov · Apr 2, 2018

Thank you Dmitry!

0 0

score 0 · Answer 2 · 2018-04-05T01:42:01-04:00

Rasha Ahamed · Apr 5, 2018

Thanks Dmitry it was helpful to me as well.

0 0

score 0 · Answer 3 · 2018-04-05T16:16:19-04:00

$translate would be better here

write $translate("12 500", " ")

To remove everything except numbers use $zstrip:

write $zstrip("12 500", "*E'N")

score 0 · Answer 4 · 2018-04-05T08:14:32-04:00

Hi,

No, you will have to find a way to remove the spaces, for example:

USER>Set ValueA = 12500

USER>Set ValueB = "12 500"

USER>Write ValueA/($Replace(ValueB," ",""))
1