2022.2

ThisfunctioncanbeusedtoextractdatafromCSVorXLS(X)filesthathaveanidenticalstructurebut
don'thavethesamecolumnnames.
index
NumberthatrepresentsacolumninaCSVorXLS(X)file(1-based).
rowOffset
Optional.Numberthatrepresentstherowindex(zero-based),relativetothecurrentposition.Toextract
thecurrentrow,specify0astherowOffset.UsemoveTo()tomovethepointerinthesourcedatafile
(see"moveTo()"onpage398).Whenomitted,thecurrentrowwillbeextracted.
Examples
Thescriptcommanddata.extractByIndex(1,0);meansthattheextractionismadeonthefirst
columninthefirstrow,relativetothecurrentposition.
Thefollowingscriptputsthevaluesofallcolumnsofthecurrentrowintoonearray.Thevaluescould
thenbestoredasaJSONarrayinasingleextractedfield.
var allFields=[];
var i=1;
while (data.fieldExistsByIndex(i)) {
allFields.push(data.extractByIndex(i++));
}
extractMeta()
MethodthatextractsthevalueofametadatafieldonacertainlevelinaPDF/VT.Thismethodalways
returnaString.
extractMeta(levelName String, propertyName String)
levelName
String,specifyingalevelinthePDF/VTorAFP.Casesensitive.
propertyName
String,specifyingthemetadatafield.
fieldExists()
Methodofthedataobjectthatreturnstrueifacertainmetadatafield,columnornodeexists.(See
"data"onpage374.)
fieldExists(levelName, propertyName)
ThismethodreturnstrueifthegivenmetadatafieldexistsatthegivenlevelinaPDF/VTorAFPfile.
levelName
Page 384