Thousand separator

Discuss MySQL Ajax Table Editor

Thousand separator

Postby mountain91074 » Tue Jan 08, 2019 9:06 am

Hi,

This may be a stupid question but I want to now how can we add a thousand separator comma to numeric values shown in table columns.
I've tried
'display_mask' => 'number_format(***)'
but does not work...

I appreciate if someone help me. Thank you.
mountain91074
 
Posts: 3
Joined: Sun Dec 30, 2018 4:30 am

Re: Thousand separator

Postby admin » Tue Jan 08, 2019 5:41 pm

You could use display_mask with a mysql function or you can use a callback function using the table_fun option.

See https://mysqlajaxtableeditor.com/Docume ... #table_fun and https://mysqlajaxtableeditor.com/Docume ... splay_mask for examples.
admin
Site Admin
 
Posts: 1502
Joined: Fri Jul 11, 2008 1:34 am

Re: Thousand separator

Postby mountain91074 » Tue Jan 08, 2019 11:08 pm

Hi admin,

Thank you.
I mede it with following code.
'display_mask' => 'format(AAA,0)'
mountain91074
 
Posts: 3
Joined: Sun Dec 30, 2018 4:30 am


Return to Open Discussion

Who is online

Users browsing this forum: Google [Bot] and 7 guests

cron