I am using $view widget to display content of a field that contains just a number. I want to display the number comma separated.
So, the number in the field is ‘123456’ but I want to display ‘123,456’.
How do I achieve that?
More generally, how do I control display of numbers? (Like specifying number of decimal places, use of commas, rounding off to the nearest integer, etc.)
A quick answer before my bed time. Get that number into a filter an you can use the mathematics operators to round, set decimal places and more. maths operators
You can, I am sure, write a filter to add the commas, I have before, but do not recall right now.
@TW_Tones Thanks. That gave me a clue.
<$text text={{{ [{!!amount}split[]butlast[3]join[]] [{!!amount}split[]last[3]join[]] +[join[,]] }}} />
is a very rudimentary solution and will work only till six digit numbers. But serves the purpose.
There’s probably a more compact way of doing this, but here’s a really long-winded solution:
\define reverse() [addsuffix<accumulator>]
<$text text={{{[<number>split[]reduce<reverse>split[]] :reduce[<index>add[1]remainder[3]match[0]then<currentTiddler>addsuffix[,]else<currentTiddler>addprefix<accumulator>] +[split[]reduce<reverse>trim:start[,]]}}} />
change the myNumber to a field.
What this does is:
1 0 3 4 5 | original number
5 4 3 0 1 | reversed number
-----------------------------
0 1 2 3 4 | index
1 2 3 4 5 | index + 1
after this step
5 4 3 , 0 1
Hello,
Give this a spin:
\define comma-separate-num() (\d)(?=(\d{3})+(?!\d))
{{{ [[234567891]search-replace:g:regexp<comma-separate-num>,[$1,]] }}}
The regular pattern above from Number formatting in JavaScript (Tom’s Blog).
Don’t ask me how that works. I’m very new to regular expressions.
\define comma-separate-num() (\d)(?=(\d{3})+(?!\d))
In Regexp, certain symbols have operator functions, much like the TW Filter Syntax. The parenthesis are “groups”, and things like ?= and ?! at the start of those groups are “look-aheads”. Your Regex (GOOD FIND) says:
Find a Digit (\d), and look forward for another set of groups (?= , the first of which is a set of 3 digits after it (\d{3}), and find as many of those as you can +, BUT if you find a single digit after the set of 3, discard the capture group (?!\d) finally, end the parent group ).
This explanation, and checking validity can be done at https://regexr.com/
@sull-vitsy Thanks. I tried your solution replacing with {!!amount} but that does not give the desired results. Am I doing something wrong?
@Charlie_Veniot Thanks! This works perfectly.
One more question. Can I not define something such that I just pass on the name of the field and it returns the comma separated number?
So, instead of having to write:
<$text text={{{ [{!!amount}search-replace:g:regexp<comma-separate-num>,[$1,]] }}} />
I will write
<$comma-separated (amount)>
I am sure, I am getting the syntax wrong. But hope, the idea is clearly expressed.
You can do it with a macro. I can’t help you more because I post from mobile.
For sure !
Sorry, just at the tail end of a coffee break and I must get back to work.
I’ll send details about macro later if somebody else hasn’t yet answered.
Sorry for reviving an old thread – wanted to give a general solution here (if only so I can find it in google search if I need it again, haha).
Uses functions, requires TW 5.3+:
\define local.separate-number.regex() (\d)(?=(\d{3})+(?!\d))
\define local.separate-number.replacement() $1$(separator)$
\function my.separate-number-input(separator:",")
[search-replace:g:regexp<local.separate-number.regex>,<local.separate-number.replacement>]
\end my.separate-number-input
\function my.separate-number(number, separator:",")
[<number>my.separate-number-input<separator>]
\end my.separate-number
Add to a new tiddler tagged $:/tags/Global and you can use anywhere:
<<my.separate-number 1234>>
1,234
Or:
{{{ [[5000]my.separate-number-input[]] }}}
5,000
Or if you’re in a locale that uses periods in this situation:
<<my.separate-number 1234567 ".">>
1.234.567
Hi all,
Just because I love one-liners:
{{{ [[12345678]split[]] :map[<revIndex>remainder[3]match[2]then<currentTiddler>addprefix[,]else<currentTiddler>] +[join[]trim[,]] }}}
This filter leverages the revIndex variable of the :map filter run prefix to insert a comma when the index of a character (counted from the end) modulo 3 is 2.
[edit]: added a second :map filter run to remove the leading comma when input length is a multiple of 3.
[edit 2]: replaced the second :map filter run by trim[,]
Fred
