2022.2

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.
XMLand JSON files
l
Property:DisplaysalistofSourceRecordpropertiessetinthePreprocessorstep(see"Pre-
processorstep"onpage249).
l
Type:DisplaysthetypeoftheSourceRecord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
XPath/JsonPath:ThepathtotheXMLfield/JSONelementthatisextracted.
ForanoverviewofXPathfunctions,seeMozilla:XPathFunctions.
ForanoverviewoftheJsonPathsyntax,seehttps://github.com/json-path/jsonpath.
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selec-
ted.
l
Trim:Selecttotrimemptycharactersatthebeginningortheendofthefield
Page 337