In this example the pipe character is used to separate data. Type the following command to set up the separator:.separator | Set up the text file you want to use to contain the query results.