Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to replace special character using regex in Mule Dataweave transformation?

Suppose I have an XML file of details of employee such as id, name and address and now I want to convert it into JSON file and before the conversation I want to replace specified special character (- , /) with blank space in address field of json document

below are my Dataweave transformation code

%dw 1.0
%output application/json
---
payload map ((payload01 , indexOfPayload01) -> {
    Id: payload01 .d as :string,
    Name: payload01.Name as :string, 
    Address: payload01.Address replace /(?)/ with " "
})

So what should I write within replace /()/ function to replace specials character , - and / with blank space?

like image 220
Aditya Avatar asked Mar 10 '23 20:03

Aditya


1 Answers

Please try the following code

Address: payload01.Address replace /([\-\,\/])/ with " "
like image 68
user3928757 Avatar answered Apr 05 '23 22:04

user3928757