I need to remove thousands separator from float column on my client's site as it some specification data and they are definitely not ready to have dot in the center of it and don't feel comfortably with it.
As I know there is no global setting for it and as I've found there is no such a setting for float data, only for integer inside column settings.
I need to change datatables js init settings somethere to disable thousands separator, I don't know how to gether access to it before table init. Any advices?
Or the other option is to find you init inside plugin and hardcode it there...
I am sorry to disappoint you, but like you said - there are no built-in options to achieve this, and a custom solution would be a lot more complicated than described on datatables.net.
There are a lot of files that need to be changed in order for this to be implemented.
Please note that customization questions like this one are not covered in the included support for the plugin. Included support covers help with bugs and general inquiries for the plugin features, but not writing custom code. As you're developing some custom solution if you need our assistance we can offer you our paid customization service.
That's disappointing and I'm not even sure why you choose this way of previewing data... As I can't use it for showing information AS IS even using export as I receive a dot in the middle of a number and it's going to be text field in excel because of it..
Frustrating and unexpected feature for me and my client.
I apologize for the inconvenience. The issue has been forwarded to our development team, and they'll look into possible implementation of this feature for some future release of the plugin.
If you don't need the column to be calculated, you can always use the String column type, so you can enter whatever information in it.
I, too, need the separator removed. It's showing up in my zip code column and in another 4 digit number column. The table this data comes from is a view created from a WP table. When looking at the structure of the view, these two columns, in particular, are listed as 'longtext' type not floats at all.
Seems this must have come up before but I cannot find any documentation or other faqs about this.
When you are posting on tickets that are not yours or have questions or issues which are not related to the title of the active ticket can you please open a new one, and we will help you there. There you can attach a link to the ticket you're referring to, so we know where to look. In that way, issues and questions which are related to different subjects will be in different tickets so other customers or our support agents can find it easily. Our policy is to have one issue or question per ticket because of the reasons that is described already.
Thank you for understanding.
If the column is set as "longtext", it is being seen as "string" type column in our plugin and is passing the values exactly as they are written in the database. So if you have a separator included, the plugin either changed the column's type to "Integer" or "float" by itself, or it is written in the source file.
When you open a new ticket, please provide that info as well, and if possible - some screenshots of the source table and what happens in wpDataTables.
I need to remove thousands separator from float column on my client's site as it some specification data and they are definitely not ready to have dot in the center of it and don't feel comfortably with it.
As I know there is no global setting for it and as I've found there is no such a setting for float data, only for integer inside column settings.
So I have options to change thousands separator to empty one according to https://datatables.net/reference/option/language.thousands:
Hello shock2d.
Thank you for your purchase.
I am sorry to disappoint you, but like you said - there are no built-in options to achieve this, and a custom solution would be a lot more complicated than described on datatables.net.
There are a lot of files that need to be changed in order for this to be implemented.
Please note that customization questions like this one are not covered in the included support for the plugin. Included support covers help with bugs and general inquiries for the plugin features, but not writing custom code. As you're developing some custom solution if you need our assistance we can offer you our paid customization service.
Best regards.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Aleksandar thanks for your reply!
That's disappointing and I'm not even sure why you choose this way of previewing data... As I can't use it for showing information AS IS even using export as I receive a dot in the middle of a number and it's going to be text field in excel because of it..
Frustrating and unexpected feature for me and my client.
Hello again Kostya.
I apologize for the inconvenience. The issue has been forwarded to our development team, and they'll look into possible implementation of this feature for some future release of the plugin.
If you don't need the column to be calculated, you can always use the String column type, so you can enter whatever information in it.
Again, sorry for the inconvenience.
Best regards.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hi Aleksandar,
I, too, need the separator removed. It's showing up in my zip code column and in another 4 digit number column. The table this data comes from is a view created from a WP table. When looking at the structure of the view, these two columns, in particular, are listed as 'longtext' type not floats at all.
Seems this must have come up before but I cannot find any documentation or other faqs about this.
Please advise.
Thanks.
Penny
Hi Penny.
When you are posting on tickets that are not yours or have questions or issues which are not related to the title of the active ticket can you please open a new one, and we will help you there. There you can attach a link to the ticket you're referring to, so we know where to look. In that way, issues and questions which are related to different subjects will be in different tickets so other customers or our support agents can find it easily. Our policy is to have one issue or question per ticket because of the reasons that is described already.
Thank you for understanding.
If the column is set as "longtext", it is being seen as "string" type column in our plugin and is passing the values exactly as they are written in the database. So if you have a separator included, the plugin either changed the column's type to "Integer" or "float" by itself, or it is written in the source file.
When you open a new ticket, please provide that info as well, and if possible - some screenshots of the source table and what happens in wpDataTables.
Best regards.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables