Hello, I would like a Dataview visualization of numbers with points as thousand separators to make the number display clearer. Below is an example:
After the visualization of 879.272 pcs
Thank you for your support!
The international recommendation is to use spaces as a thousand separator so as not to confuse with the decimal point, but if you insist on using the point, just replace the "$& " with "$&.".
Here is a note showing how to do a regexreplace() to add the thousand separator.
---
cases: [1, 20, 300, 4000, 50000, 600000, 7000000, 80000000, 900000000, 1000000000]
---
```dataview
LIST WITHOUT ID regexreplace(string(number), "[0-9](?=(?:[0-9]{3})+(?![0-9]))", "$& ")
FLATTEN cases as number
WHERE file = this.file
```
Which displays as:
It works perfectly, thank you so much!!!
1 Like