Editing Fields In Fixed Width Data Text Files

Text files can be used as a source or target datastore and are accessed using the Text File As A Source or Text File As A Target Connector. On the Source Text Connection — Entities Tab or the Target Text Connection — Entities Tab of the Text Connection dialog you can indicate whether the text file you are using is Delimited or Fixed Width. See Fixed Width Data In Source And Target Text Files.

If you selected Fixed Width on the Text Connection Entities tab and did not select Field Names for the First Row setting, TIBCO Cloud™ Integration - Connect creates a single field, called Field1 on the Text Connection Fields tab. You may want to add, delete, or edit fields on the Fields tab for this text file.

Source Text Connection — Fixed Width Data

Adding A Field

1. From the Text Connection Fields tab, select an Entity from the Entities column in the left pane.
2. Select Field1 to display the Gear menu for the row.
3. From the Gear menu select either Add above or Add below. A new field, called NewField is added.
4. Select the field name and type over it to enter a new name.
5. Change any field properties as needed. For detailed information on field properties see the Fields Tab Fields for the Source Text Connection or the Fields Tab Fields for the Target Text Connection.

Deleting A Field

1. From the Text Connection Fields tab, select an Entity from the Entities column in the left pane.
2. Select a the field to be deleted to display the Gear menu for the row.
3. From the Gear menu select Delete.

The field is deleted from your entity. Keep in mind that:

• If you delete a field from within the entity, all of the data is shifted, which may require you to reformat the fields after the deleted field.
• You cannot add the field back into the same location. If you add fields, they are always appended to the end of the entity.
• If you delete a field has already been included in a flow, the flow displays an error until you delete the link as well.

Refreshing The Schema

In the Fields tab use Refresh schema on the Gear menu for the Entity to reset the field names and data types to the original source names and formats. Note that Refresh schema resets all of your data, not just selected fields.

Related Topics

Source Text Connection — Fields Tab

Target Text Connection — Fields Tab

Fixed Width Data In Source And Target Text Files