Difference between revisions of "Parse File Action"
(→Parsing HTML or RTF Tables) |
(→Parsing HTML or RTF Tables) |
||
Line 15: | Line 15: | ||
===== Parsing HTML or RTF Tables ===== | ===== Parsing HTML or RTF Tables ===== | ||
+ | Once we have chosen the type of file we are going to parse, and the url we can hit populate. | ||
− | + | This pre parses the table in the file and returns a list of available cells. | |
− | a list of available cells | + | |
− | + | ||
− | + | You then probably need to delete the cells you aren't interested in, along with the cells that contain data as opposed to the cells that contain fields. | |
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, |
Revision as of 12:49, 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
Once we have chosen the type of file we are going to parse, and the url we can hit populate.
This pre parses the table in the file and returns a list of available cells.
You then probably need to delete the cells you aren't interested in, along with the cells that contain data as opposed to the cells that contain fields.
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