2022.2

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.
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.
l
Currency Sign:Setthecurrencysignforacurrencyvalue.
l
Treat empty as 0:Anumericalemptyvalueistreatedasa0value.
l
Date/Time Format:Setthedateformatforadatevalue.
l
Automatic:Selectthisoptiontoparsedatesautomatically,withoutspecifyinga
format.ThisisthedefaultsettingfornewDatefields.
l
ISO8601:Thissettingallowsfordateswithdifferenttimestampformats,orbelonging
todifferenttimezones,tobeparsedinsideasinglejob.Datesthatdonotincludea
specifictimeareautomaticallyconsideredtousethecurrentlocale'stimezone.
SelecttheISOtemplatetobeusedwhenparsingthetimestamp.OtherISO8601
formatscanbehandledviatheCustomoption.
l
Custom:Setacustomdateformat.ForthemarkersavailableintheDataMappersee
"Date"onpage278.
l
Date Language:Setthelanguageforadatevalue(ex:IfEnglishisselected,thetermMay
willbeidentifiedasthemonthofMay).
l
Use offset from UTC:Selectthedefaulttimezone,whichistobeusedtoextractany
timestampthatdoesnotalreadyincludetimezoneinformationwiththetime.
Page 335