Parse File Action

From PresenceWiki
Revision as of 12:47, 11 November 2010 by Graham (Talk | contribs)

Jump to: navigation, search

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 file we are going to parse, we can hit populate, this gets presence to pre parse the file and return 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.

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