Unplanned
Last Updated: 21 Mar 2024 08:06 by Domenico
Meindert
Created on: 23 Aug 2022 13:56
Category: Grid
Type: Feature Request
12
Option to configure the field delimiter when exporting to CSV

Please expose an option to configure the field delimiter for CSV export. I want to set semicolon as field delimiter instead of a comma.

---

ADMIN EDIT

---

Internally the Grid uses SpreadStreamProcessing library to perform the export. That said, a necessary prerequisite to implement the current enhancement is that SpreadStreamProcessing supports settings for changing the delimiter when exporting to CSV. You may vote for the item and follow it to get status email updates.

For the time being, you may customize the exported file to set the desired field separator as suggested in the Grid CSV export - change the comma field delimiter knowledge base article.

5 comments
Domenico
Posted on: 21 Mar 2024 08:06
Hi, this feature is quite important because when you got a text in a field, there are mostly commas in that text. Then you got troubles to define which comma is a delimiter and what is text. Thanks for helping
ADMIN
Dimo
Posted on: 10 Jul 2023 06:19

Hello Christian,

I see that you have already voted for the SpreadStreamProcessing delimiter feature request that we depend on to make this work. Thanks for that.

I forwarded your post to the product team for consideration. You may also want to copy your notes in the linked request, so that they are visible to the Document Processing product community.

Regards,
Dimo
Progress Telerik

As of R2 2023, the default icon type will be SVG instead of Font. See this blogpost for more information.
Christian
Posted on: 03 Jul 2023 13:11
This would be a nice (And I guess also simple to implement) feature. Especially in German speaking countries, Excel is quite stupid dealing with the default comma as separator and puts everything into one column by default... If you use a semicolon instead, it works properly. (Yes, there is an option to import data per CSV, but it's not the easy one-click-solution you could have).
ADMIN
Nadezhda Tacheva
Posted on: 28 Nov 2022 11:46

Hi Meindert,

The item is currently not included in the near-term roadmap. We are normally planning the component enhancements based on the community demand and we track the gathered community votes to evaluate that.

In this specific scenario, there is also a necessary prerequisite to be completed prior to implementing the feature in the Blazor Grid. As its export uses the SpreadStreamProcessing library, it is required that the SpreadStreamProcessing library supports a delimiter setting in general. That said, you can also track that implementation as well.

For the time being, you may use the suggested delimiter customization through the OnAfterExport event.

Regards,
Nadezhda Tacheva
Progress Telerik

Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.

Meindert
Posted on: 25 Nov 2022 08:03
Does this have attention in the near future, besides the number of votes?