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
Parsing HTML or RTF Tables
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