 How To Change Delimiters

CSV files have counterparts that use other delimiters. For example, .tsv files use tabs, instead of commas. Likewise .psv use the | character. FlightPath lets you set the delimiter for a file and switch delimiter when you save a file.

How to do it

• Open a .csv file. You can use the Examples files.
• In the Grid View, look to the top of the screen for the Data Toolbar

• The Data Tool bar has drop-downs for delimiters and quote chars. The delimiter should have defaulted to Comma.
• Click shift-control-s to save-as the file (or select Save-as on the context menu)

• In the Save-as dialog select a new delimiter. Try Pipe. When you select Pipe FlightPath adds a .psv to the end of the file path.
• Close the file by clicking the [x] in the files tab
• Reopen the file by clicking its name in the project files tree on the left
• Your file will open with a single column. It will look wrong.

• In the Data Toolbar, select the pipe delimiter.
• Your file should open up to its correct form because the delimiter is now correct