 | This guide will help you learn how to configure the TextFile connector to read from or write to a CSV or TXT file. |
Creating a new CSV/TXT File
Please follow these steps:
- Drag-and-drop the TextFile connector icon onto Apatar's main panel.
- Double-click on the connector's node to configure it.
- In the window that pops-up, check Create a new file.
- Click Choose Folder to specify the path to the file to be created by browsing your hard drive, or, alternatively, input the path manually into the Folder Name field.
- In the New File Name field, input the name of the file to be created.
- The default extension for the file to be created is .txt. If you want Apatar to create a .csv file, click on the list to the right from the New File Name field and choose .csv.
- Now, you have to add the fields for your text file. Input the field's name into New Fields in the Textfile and press Add field to create a field with the specified name.
To delete a field, select it and press Delete Field.
- The default separator between the fields is comma. If you have chosen to create a .txt file, you can also choose semicolon, bar (|), and tab (->) from the Choose Separator list. Please note that since CSV stands for Comma-Separated Values, comma is the typical field separator for this file extension.
- Click Next.
- From the list of the created fields, select the ones you want to operate in Apatar by holding the Control key and clicking on their names.
- Click Finish. Now, you can start working with a new text file in Apatar.
Reading from a CSV/TXT file
Please follow these steps:
- Drag-and-drop the TextFile connector icon onto Apatar's main panel.
- Double-click on the connector's node to configure it.
- Check Choose File Name in the window that appears.
- Press Choose to browse your hard drive and locate the desired file.
- Click Next.
- From the list of the fields that the file contents, select the ones you want to operate in Apatar by holding the Control key and clicking on their names.
- Click Finish.
- Now, the text file is configured and ready to be mapped to an operation node.
