2022.2

Table Of Contents
l
Ignore unparseable lines:Ignoresanylinethatdoesnotcorrespondtothesettingsabove.
l
Skip empty lines:Ignoreanylinethathasnocontent.Notethatspacesareconsideredcontent.
l
Sort on:Selectafieldonwhichtosortthedata,inascending(A-Z)ordescending(Z-A)
order.Notethatsortingisalwaystextual.Eveniftheselectedcolumnhasnumbers,itwill
besortedasatext.
Excel file Input Data settings
TherearenosettingsforfieldseparationinanExcelfile,onlysettingswithregardstothefileasa
whole.
l
Lines to skip:DefinesanumberoflinesintheExcelfilethatwillbeskippedandnotusedas
records.
l
First row contains field names:CheckthisoptiontousethefirstlineoftheExcelfileashead-
ers.Thisoptionautomaticallynamesallextractedfields.
l
Sheet:Onlyonesheetcanbeselectedasthedatasource.
l
Skip empty lines:Ignoreanylinethathasnocontent.Notethatspacesareconsideredcontent.
l
Sort on:Selectafieldonwhichtosortthedata,inascending(A-Z)ordescending(Z-A)
order.Notethatsortingisalwaystextual.Eveniftheselectedcolumnhasnumbers,itwill
besortedasatext.
PDF file Input Data settings
ThesesettingsalsoapplytofilesthatareconvertedtoPDFbytheDataMapper:PS,PCLandAFPfiles.
PDFFileshaveanatural,staticdelimiterintheformofpages,sotheoptionshereareinterpretationset-
tingsfortextinthePDFfile.
TheInputDatasettingsforPDFfilesdeterminehowwords,linesandparagraphsaredetectedinthe
PDFwhencreatingdataselections.
Eachvaluerepresentsafractionoftheaveragefontsizeoftextinadataselection,meaning"0.3"rep-
resents30%oftheheightorwidth.
l
Word spacing:Determinesthespacingbetweenwords.AsPDFtextspacingissomehowdone
throughpositioninginsteadofactualtextspaces,textpositioniswhatisusedtofindnewwords.
Thisoptiondetermineswhatpercentageoftheaveragewidthofasinglecharacterneedstobe
emptytoconsideranewwordhasstarted.Thedefaultvalueis0.3,meaningaspaceisassumed
ifthereisablankareaof30%ofthewidthoftheaveragecharacterinthefont.
l
Line spacing:Determinesthespacingbetweenlinesoftext.Thedefaultvalueis1,meaningthe
spacebetweenlinesmustbeequaltoatleasttheaveragecharacterheight.
Page 308