2022.2

Note: AJsonPathexpressioncandefinemorethanoneitem(forexample:.*returnsany-
thinginthecurrentelement).Ifmorethanoneitemisreturned,theExtractstepwillkeep
anarrayofallreturneditems.
ThefullJsonPathtoanelementisdisplayedatthebottomleftofthewindowwhenyouselectit.
Tocopythepath,right-clickitandselectCopy.
l
Use selection:Clicktousethevalueofthecurrentdataselectionfortheextraction.
Note: IfakeyinaJSONfilehasanamethatlookslikeafunction(e.g."TLIST(A1)"),then
theExtractstephastouseaJsonPathwithbracketnotationinsteadofthedefaultdotnota-
tion.Forinformationaboutthebracketnotationsee
https://goessner.net/articles/JsonPath/.
l
Post Function:EnteraJavaScriptexpressiontoberunaftertheextraction.For
examplereplace("-","")wouldreplaceasingledashcharacterinsidetheextractedstring.
l
Use JavaScript Editor:Clicktodisplaythe"boundaries"onpage370dialog.
l
Trim:Selecttotrimemptycharactersatthebeginningortheendofthefield.
Data Format
Formatsettingscanbedefinedinthreeplaces:intheuserpreferences("DataMapperpreferences"on
page786),thecurrentdatamappingconfiguration("Dataformatsettings"onpage226)andperfield
viatheStepproperties.
Anyformatsettingsspecifiedperfieldarealwaysused,regardlessoftheuserpreferencesordata
sourcesettings.
Note: DataformatsettingstelltheDataMapperhowtoreadandparsedatafrom the data
source.Theydon'tdeterminehowthesedataareformattedintheDataModelorinatemplate.In
theDataModel,dataareconvertedtothenativedatatype.Dates,forexample,areconvertedto
aDateTimeobject.HowtheyaredisplayedintheDataModeldependsonthepreferences(see
"DefaultFormat"onpage786).
l
Negative Sign Before:Anyvalueinanumericfieldthathasa"-"signisinterpretedasaneg-
ative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.
Page 331