Split delimited string and store values in JSON object using dataweave

Question

I have a CSV file which sends records in the following format:

John,Smith,presentation|researcher|developer,[email protected],07891234567

I need to take each record and map them to a list of the following JSON object:

[
   {
      "firstName": "John",
      "surname": "Smith",
      "skills": 
      [
         "presentation",
         "developer",
         "researcher"
      ]
      "email": "[email protected]",
      "phone": "07891234567"
   }
[

My problem is that how do you split the address text string and populate the address object along with the other fields using Dataweave and the Transform message component in Mule 3.8.1?

Thanks

The Mighty Programmer · Accepted Answer · 2016-11-30 05:09:18Z

2

You can use the splitBy to get what you are wanting.

%dw 1.0
%input payload application/csv
%output application/json
---
payload map {
  firstname: $.firstname,
  lastname: $.lastname,
  skills: $.skills splitBy ('|'),
  email: $.email,
  phone: $.phone
}

edited Nov 30, 2016 at 5:09

The Mighty Programmer

1,25212 silver badges24 bronze badges

answered Nov 29, 2016 at 23:59

Chad Gorshing

3,13833 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Split delimited string and store values in JSON object using dataweave

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related