Parse Dates with DataWeave
These DataWeave examples define a function (fun) in the DataWeave header to normalize date separators (/, ., and -) within different date formats so that all of them use the same separator (-).
The examples use these functions:
-
replaceso that all dates match a single pattern. -
mapObjectto run through thedateelements. The script applies the normalizing function to eachdate. -
as(in the second DataWeave script) to change the data type of the values to a Date type with a specific date format.
Example: Returns Dates as String Types
DataWeave Script:
%dw 2.0
output application/xml
fun normalize(date) = (date) replace "/" with "-" replace "." with "-"
---
dates: (payload.dates mapObject {
normalized_as_string: normalize($)
})Input XML Payload:
<dates>
<date>26-JUL-16</date>
<date>27/JUL/16</date>
<date>28.JUL.16</date>
</dates>Output XML:
<?xml version='1.0' encoding='US-ASCII'?>
<dates>
<normalized_as_string>26-JUL-16</normalized_as_string>
<normalized_as_string>27-JUL-16</normalized_as_string>
<normalized_as_string>28-JUL-16</normalized_as_string>
</dates>Example: Returns Dates as Date Types
DataWeave Script:
%dw 2.0
output application/xml
fun normalize(date) = (date) replace "/" with "-" replace "." with "-"
---
// Outputs date values as Date types in the specified format
dates: (payload.dates mapObject {
normalized_as_date: (normalize($) as Date {format: "d-MMM-yy"})
})Input XML Payload:
<dates>
<date>26-JUL-16</date>
<date>27/JUL/16</date>
<date>28.JUL.16</date>
</dates>Output XML:
<?xml version='1.0' encoding='UTF-8'?>
<dates>
<normalized_as_date>2016-07-26</normalized_as_date>
<normalized_as_date>2016-07-27</normalized_as_date>
<normalized_as_date>2016-07-28</normalized_as_date>
</dates>