DQ.EXTRACT Function

Extracts attributes from a string.

Category:	Data Quality
Returned data type:	Character
Note:	The returned value is a value, token, or token value from the extract function.

Syntax

Required Arguments

Details

Example

Syntax

DQ.EXTRACTdefinition, string

Required Arguments

definition

a string representing the name of the extraction definition in the QKB.

string

a string that represents the attribute that needs to be extracted.

Details

The DQ.EXTRACT function extracts attributes from a string into tokens. The first parameter is the name of the QKB extraction definition. The second is the string where the attributes are extracted. This function returns a number of tokens that were created. It returns 0 if it fails.

Example

data quality dq
string output
integer o
integer i
 
/* Initialize DQ */
dq = dq_initialize()
dq.loadqkb("EN")
 
/* Extract using the "Product Attributes" Extraction definition (using QKB PD 2012A) */
o = dq.extract("Product Attributes", "DOOR RANCHERO WOOD 16X8 WHT")
 
/* print all of the tokens we got */
print (o & " tokens filled")
for i = 1 to o
begin
     dq.token(i, output)
     print ("token #" & i & " = " & output)
     dq.value(i, output)
     print ("value #" & i & " = " & output)
end
/* to get a token's value by its name... */
dq.tokenvalue("Colors", output)
print ("Colors = " & output)