CSV File Manipulations

'Convert XLS' provides various data manipulation options for your CSV files. They are:

• Surround field with quotes
• Pad field with spaces
• Change comma to other delimiter
• Remove empty lines
• Include specified ROWS, discard all others
• Include specified COLUMNS, discard all others
• Remove control characters
• Trim excess commas
• Pad field(s) to a fixed length

You may implement any of the above by following these steps

1. Select the Special Process in the drop down list box. The file format is automatically set as CSV.
2. Next select the input and output files. The input file MUST be in CSV format. If an output file does not exist, Convert XLS will create it for you.
3. Fill out any other text boxes that may appear below the Select Output Files text box that may appear depending on which special process you selected.
4. In order to view the changes in the CSV file, open it with a text editor (such as Notepad) or a word processing application (such as MS Word).

Note: By default, if you have MS Excel installed, opening a csv file cause MS Excel to display the file. You won't necessarily be able to view the changes that were made to the file in MS Excel. That is why we recommend opening the file from Notepad or a similar text file editor.