csv file conversion

[bvtvusn]

What feature or new tool do you think should be added to DevToys?

A feature for converting csv files would be nice. It should be able to replace the separator character (comma, semicolon, tab etc.) and also be able to enclose every element in quotation marks.

Why do you think this is needed?

Csv files are used to import and export various types of data, and often theese use different separator characters. It is not always possible to do a simple search and replace operation, because the separator character may exist between the quotation marks and it should not be changed.

Solution/Idea

specify source format (delimiter, quotation marks) Specify destination format (delimiter, quotation marks)

Comments

No response

[JeReT]

Great Idea. When it comes to parsing a csv, you might stumble upon some other hurdles as well. For example, a BOM at the start of the file or the encoding (e.g. Excel uses Unicode when exporting to csv, not UTF8). So, removing / adding a BOM and changing the encoding and saving all the settings as a template and be able to bulk convert using the template would be good.