Difference between revisions of "Parse File Action"
(→Parsing HTML or RTF Tables) |
(→Parsing HTML or RTF Tables) |
||
Line 16: | Line 16: | ||
In the case of a table the data is first read in as a 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, | 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. | such as pt(0,0) or text to search for, such as TEAM NAME. | ||
+ | |||
When it finds this cell it will then return:- | When it finds this cell it will then return:- | ||
Revision as of 12:29, 11 November 2010
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