Difference between revisions of "Parse File Action"

From PresenceWiki
Jump to: navigation, search
(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