OpenFileForReading

OpenFileForReading

What to use it for

Prerequisites for usage

Essential properties to set

Use OpenFileForReading in case you want to process a text file line per line, so that each line becomes a single element that you can use further in the Workflow. One scenario is processing tabular data that is saved to a CSV file. Each line is a new table row.

Use ReadFromFile in case you want to process a complete text file all at once.

 
  • Path
  • Foreach
  • In
  • Body

Misc

OptionWhat is itHow to use
PathThe full path to a file that you want to open for reading.

Enter a path to the file, that includes file name and extension.

You can enter the following:

  • Absolute folder path.
  • Relative folder path (not recommended).
  • VisualBasic expression that results in a folder path.

Recommended: Enter an absolute path that includes file name and extension.

Do not use binary files. Recommended: Plain text files.

For each line in file: Foreach

Indicates that it will process line per line.Recommended: Do no change.

For each line in file: In (lines)

Indicates that it will process lines.Recommended: Do not change.
BodySequence of Activities to work on each line of the file.

Use the body as a miniature Sequence Activity: Drag Activities to the Body, and set their properties.

Display nameName of the Activity.Leave at default, or edit the name to reflect

 

 

File system Activities

CSV Activities