Dataview plugin snippet showcase

[holroy]

@SimonW

I’ve just started playing around with Dataview and I am having problems with thousands separators (comma’s) in numbers.
…
Even if I could format the output correctly that would be a win.

Someone else asked a similar question, and then I found this post, and a hack to provide a solution for you as well.

Dataview numbers display with comma separation

Do you mean to present a number like 1234567.12 as 1,234,567.12? I don’t think there is any support for presenting number like that currently. This post mentions it, but just as a question. A quick search indicates you can hack a solution using regex, so maybe something like the following would work in your case: ```dataview TABLE regexreplace(round(sum(rows.amount), 2), "\B(?=(\d{3})+(?!\d))", ",") as "Total amount" FROM "/Area" GROUP BY date ```

The trick/hack is to use regexreplace() to insert the thousand separator. So do something like the below to achieve the output. I suggest keeping the numbers as numbers, so you can keep using them for calculations.

`= regexreplace("1234567.12", "\B(?=(\d{3})+(?!\d))", ",") `

TABLE regexreplace(someNumberField, "\B(?=(\d{3})+(?!\d))", ",") as "nice number"
....

Hope this helps, and that you’re still in search for this answer…