2022.2

CSV and Database Files
l
Property:DisplaysalistofrecordpropertiessetinthePreprocessorstep(see"Preprocessor
step"onpage249).
l
Type:Displaysthetypeoftheproperty.Readonlyfield.
l
Based on:Determinestheoriginofthedata.
l
Location:Thecontentsofthedataselectionsetbelowwillbethevalueoftheextracted
field.Thedataselectionsettingsaredifferentdependingonthedatasampletype.
l
Column:Drop-downlistingallfieldsintheDataSample,ofwhichthevaluewillbe
used.
l
Top offset:TheverticaloffsetfromthecurrentpointerlocationintheDataSample
(Viewer).
l
Use selection:Clicktousethevalueofthecurrentdataselectionfortheextraction.
Iftheselectioncontainsmultiplelines,onlythefirstlineisselected.
l
Trim:Selecttotrimemptycharactersatthebeginningortheendofthefield
l
JavaScript :TheresultoftheJavaScriptExpressionwrittenbelowthedrop-downwillbe
thevalueoftheextractedfield.Iftheexpressioncontainsmultiplelines,thelastvalueattri-
bution(variable="value";)willbethevalue.See"DataMapperScriptsAPI"onpage360.
l
Expression:TheJavaScriptexpressiontorun.
l
Use JavaScript Editor:ClicktodisplaytheEditScriptdialog(see"Usingscriptsin
theDataMapper"onpage362and"DataMapperScriptsAPI"onpage360).
l
Use selected text:InsertsthetextinthecurrentdataselectionintheJavaScript
Expression.Ifmultiplelinesorelementsareselected,onlythefirstoneisused.
l
Use selection:Clicktousethevalueofthecurrentdataselectionfortheextraction.
Note: Iftheselectioncontainsmultiplelines,onlythefirstlineisselected.
l
Data Format:DataformatsettingstelltheDataMapperhowcertaintypesofdataareformatted
in the data source.Makesurethatthisformatmatchestheactualformatofthedatainthedata
source.
l
Negative Sign Before:Anyvalueinanumericfieldthathasa"-"signisinterpretedasa
negativevalue.
l
Decimal Separator:Setthedecimalseparatorforanumericalvalue.
l
Thousand Separator:Setthethousandseparatorforanumericalvalue.
Page 336