Parse Row Collection

Sepasoft MES Module Suite

The Parse Row Collection object contains one or more ParseRow objects. Each ParseRow object contains one or more ParseValue objects. When results contain values from a CSV source, there are rows and columns. As the image below depicts, CSV data is transformed into a ParseResults object.

CSVToParseResults

Properties

isValid()

Description

Returns true if all parse values within all parse rows are valid.

Syntax

isValid()

Parameters

None

Returns

If true indicates that all parse values within all parse rows are valid.

Scope

All

isRequiredValid()

Description

Returns true if all parse values within all parse rows are required and are valid.

Syntax

isRequiredValid()

Parameters

None

Returns

If true indicates that all parse values within all parse rows are required and are valid.

Scope

All

isRequired()

Description

Returns true if at least one parse values within all parse rows is required.

Syntax

isRequired()

Parameters

None

Returns

If true indicates that at least one parse values within all parse rows is required.

Scope

All

getParseRows()

Description

Returns a list of all parse rows contained in this collection.

Syntax

getParseRows()

Parameters

None

Returns

A List of ParseRow objects contained in this collection.

Scope

All

Code Examples

Copy Code

Code

#Sample script to cycle though all parse value contained in parse rows:
from org.apache.log4j import Logger
log = Logger.getLogger("ParseResult")
fileStr = system.file.readFileAsString("C:\Temp\Test.csv")
parseResults = system.instrument.parse.parseText("CSV Test Column", fileStr)
if parseResults.isValid():
 rowCollection = parseResults.getRowCollection("CSV Results")
 parseRowList = rowCollection.getParseRows()
 for parseRow in parseRowList:
         parseValueList = parseRow.getParseValues()
         for parseValue in parseValueList:
                 log.info("%s = %s" % (parseValue.getName(), str(parseValue.getValue())))

Sepasoft MES Module Suite