The functions and options for processing CSV data can be found in the area "Actions > CSV" on the right side of the main window of the TextConverter. With these functions you can edit texts or text files as part of a CSV structure. This means that you can perform actions limited to certain fields of the CSV table or, for example, delete, add, copy or move columns.
Characters for Field Separation, Field Delimitation and Line End
Which characters are used to determine the CSV structure can be determined freely in the TextConverter. You are not only bound to the classic characters such as comma, semicolon or double quotation mark but also you can define arbitrary characters or code points for all CSV parameters. Fields can also be defined via a fixed number of characters and the definition of multiple characters or codepoints, which are to be interpreted independently of each other as field separation characters, is also possible.
The settings for the field separator and the field delimiter can be found under "Actions > CSV > Import Format" and "Actions > CSV > Export Format" in the TextConverter. The end of the line can be configured via "Actions > Files > Line Break Type". In addition to the definition of characters or codepoints, also the end of the line can alternatively be definied by fixed line lengths as well as multiple characters or codepoints.
Settings and Actions for CSV Editing
In the current version of the TextConverter, the following settings and actions for processing CSV files as well as data within a CSV structure are available:
- Import Format
- Export Format
- Replace Fields
- Replace in Fields
- Delete Columns
- Delete Text from Fields
- Trim Fields
- Prepend and Append Text to Fields
- Insert Text in Fields
- Add Columns
- Change Writing of Text in Fields
- Copy Columns
- Column Order
- Rotate and Mirror
- Action Lists
- Conversion of CSV Data into other Formats
Conversion of CSV Data into other Formats
In addition to the actions for processing CSV data from the section "Actions > CSV", you can find further CSV actions in the area "Actions > Format" with which you can convert CSV data to other formats. For example, with this actions, it is possible to convert a CSV table to an HTML table, to transfer data from a CSV structure into an XML structure or to generate SQL instructions from CSV data.
CSV Processing with the old Program Version
Also the old version of the TextConverter already had the opportunity to process CSV files. However, the possibilities compared to the current program version were significantly reduced. There were significantly fewer actions and the options for import and export were less flexible. If you still use the old version or if you would like to find out more about the old version, you can find the introduction to the old version of the TextConverter Pro CSV here.