2022.2

Extract the sum or totals.Iftherecordcontainssumsortotalsattheendofthelineitemslist,
theendoftheRepeatstepisagoodplacetoaddanExtractstepforthesedata.Aftertheloop
step,thecursorpositionisattheendoflineitems.Alternatively,right-clickontheendofthe
RepeatstepintheStepspanelandselectAdd a Step > Add Extraction.
Tip: Thishow-todescribesindetailhowtoextractanitemdescriptionthatappearsinavariable
numberoflines:Howtoextractmultilineitems.
Extractingdataofvariablelength
InPDFandTextfiles,transactionaldataisn'tstructureduniformly,asinaCSV,databaseorXMLfile.
Datacanbelocatedanywhereonapage.Therefore,dataareextractedfromacertainregiononthe
page.However,thedatacanbespreadovermultiplelinesandmultiplepages:
l
Lineitemsmaycontinueonthenextpage,separatedfromthelineitemsonthefirstpagebya
pagebreak,anumberofemptylinesandaletterhead.
l
Datamayvaryinlength:aproductdescriptionforexamplemayormaynotfitononeline.
Howtoexcludelinesfromanextractionisexplainedinanothertopic:"Extractingtransactionaldata"on
page235(seeFromaPDForTextfile).
Thistopicexplainsafewwaystoextractavariablenumberoflines.
Text file: setting the height to 0
IfthevariablepartinaTXTfileisattheendoftherecord(forexample,thebodyofanemail)theheight
oftheregiontoextractcanbesetto0.ThisinstructstheDataMappertoextractalllinesstartingfrom
thecurrentpositioninarecorduntiltheendoftherecord,andstoretheminasinglefield.
Thisalsoworkswiththedata.extract()methodinascript;see"extract()"onpage375.
Page 245