Difference between revisions of "Parse File Action"
Line 27: | Line 27: | ||
Chars At Cell | Chars At Cell | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
Given the the rtf file we have below, let us say we want to extract the 2 Contact Telephone Numbers, the | Given the the rtf file we have below, let us say we want to extract the 2 Contact Telephone Numbers, the | ||
Line 47: | Line 39: | ||
http://www.international-presence.com/images/docs/fileparser/fileparserresults.png | http://www.international-presence.com/images/docs/fileparser/fileparserresults.png | ||
+ | |||
+ | Chars Before | ||
+ | |||
+ | Chars After | ||
+ | |||
+ | Chars Between | ||
+ | |||
+ | Chars At Positions |
Revision as of 09:53, 1 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
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