Parse File Action

http://www.international-presence.com/images/docs/fileparser/fileparser_header.png

parse File Action Node

The purpose of this node is to convert data found within a file into a dataset.

The files that we can convert are:-

• RTF Table
• RTF
• Text
• HTML
• HTML Table
• CSV Table

In the case of a table the data is first read in as a table. We can then get the parser to search for a cell by giving it either a location, such as pt(0,0) or text to search for, such as TEAM NAME. When it finds this cell it will then return:-

Cell Above

Cell Right

Cell Below

Cell Left

Chars At Cell

Given the the rtf file we have below, let us say we want to extract the 2 Contact Telephone Numbers, the Team Name and the Team Location.

http://www.international-presence.com/images/docs/fileparser/rtffile.png

http://www.international-presence.com/images/docs/fileparser/fileparserscan.png

http://www.international-presence.com/images/docs/fileparser/fileparseroutput.png

http://www.international-presence.com/images/docs/fileparser/fileparserresults.png

Chars Before

Chars After

Chars Between

Chars At Positions