LB Booster
Programming >> Language extensions >> Non-standard thousands separators
http://lbb.conforums.com/index.cgi?board=extensions&action=display&num=1416653255
Non-standard thousands separators
Post by Richard Russell on Nov 22nd, 2014, 09:47am

I received this query by email:

Quote:
I tried to put 1221 in a format like: 1 221.000
The lower comma used locally as decimal point so I can't use it.

One of the LBB extensions is to format a number with 'thousands separators', but the only supported separator character is a comma - which as the OP says is used in some regions as the 'decimal point'. An easy way to achieve the desired result is firstly to format it with comma separators, and then change the commas to spaces:

Code:
print format$(1221)
end

function format$(number)
  format$ = using("#,###,###.###", number)
  do
    i = instr(format$, ",")
    if i then mid$(format$, i, 1) = " "
  loop until i = 0
end function

Richard.