Difference between revisions of "Parse File Action"

From PresenceWiki
Jump to: navigation, search
(parse File Action Node)
(parse File Action Node)
Line 12: Line 12:
 
*HTML Table
 
*HTML Table
 
*CSV Table
 
*CSV Table
 +
 +
[[Parsing HTML or RTF Tables]]
  
 
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.

Revision as of 12:28, 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