Difference between revisions of "Parse File Action"

From PresenceWiki
Jump to: navigation, search
(parse File Action Node)
Line 6: Line 6:
 
The files that we can convert are:-
 
The files that we can convert are:-
  
RTF Table
+
*RTF Table
RTF
+
*RTF
Text
+
*Text
HTML
+
*HTML
HTML Table
+
*HTML Table
CSV Table
+
*CSV Table
  
 
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:27, 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

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