Mule dataweave: convert decimal to an integer

Question

I want to convert a decimal (78.22) to an integer (78) using Dataweave.

<root>
<MoneyAmountRequired>78.22</MoneyAmountRequired>
</root>

I try as below and it doesn't work if I add default 0

moneyAmountRequired: payload.root.MoneyAmountRequired as :number{format: "0"} default 0

Can some one please point out why it doesn't work when default 0 is present.

Thank you!

score 2 · Answer 1 · answered Mar 10 '17 at 12:13

2

Use floor function of dataweave.

{
    root: {
        MoneyAmountRequired: floor payload.root.MoneyAmountRequired
    }
}

answered Mar 10 '17 at 12:13

Venu

19
3

score 0 · Answer 2 · edited May 23 '17 at 12:18

0

You can try the following :-

moneyAmountRequired: payload.root.MoneyAmountRequired as :string {format: "0"}as :number default 0

Here you need to convert it first in String as :string then in number as :number
This is the only way it seems to work !!
ref:- Mule Dataweave format :number

edited May 23 '17 at 12:18

Community

1
1

answered May 17 '16 at 20:16

Anirban Sen Chowdhary

8,233
6
39
81

The problem is having default 0. I want to have a default value if the value is not present but if I keep it, I can't convert decimal to integer. as :number {format: "0"} works perfectly fine without default 0 – Neil24 May 18 '16 at 08:22

score 0 · Answer 3 · answered May 18 '16 at 13:21

0

Try myvalue: removeDecimal(28.23)

answered May 18 '16 at 13:21

Satheesh Kumar

797
7
31

I get "There is no variable named 'removeDecimal' " – Neil24 May 18 '16 at 13:40
Can I know how you are doing it,because am getting it properly its a function call. can you post the dataweave script – Satheesh Kumar May 19 '16 at 08:42

AnupamBhusari · Answer 4 · 2016-05-19T09:10:45.583

0

This works for me.

moneyAmountRequired: payload.root.MoneyAmountRequired as :number {format: "##,##"} as :string {format: "##"} as :number

Hope this helps.

edited May 19 '16 at 09:10

answered May 19 '16 at 08:53

AnupamBhusari

2,395
2
14
22

himanshu · Answer 5 · 2016-09-27T20:27:28.680

0

Check this: %dw 1.0 %output application/java

%var regex = /(.\d+?)0+\b/

data replace regex with ""

edited Sep 27 '16 at 20:27

answered Sep 16 '16 at 20:40

himanshu

21
2
8

3

Hi, do add a bit of explanation along with the code as it helps to understand your code. Code only answers are frowned upon. – Bhargav Rao Sep 16 '16 at 20:41

devmaker64 · Answer 6 · 2017-01-27T09:31:16.583

0

((payload.root.MoneyAmountRequired as :string) splitBy '.')[0] as :number

If you prefer to use a function, then:

%function truncateDecimals(d) ((d as :string) splitBy '.')[0] as :number when d != null otherwise d
---
{value: truncateDecimals(payload.root.MoneyAmountRequired)}

edited Jan 27 '17 at 09:31

answered Oct 28 '16 at 22:01

devmaker64

1
2

There is a nice preview function that allows you to format your code correctly. Perhaps try it? – techydesigner Oct 29 '16 at 00:15

score 0 · Answer 7 · answered Jan 27 '17 at 09:25

After the number is formatted, it is indeed a string, but you are defaulting it to a number 0 instead of defaulting it to a string "0". But that would be enough if 'as :number' did not failed when the variable is null, which is in the first place the reason you need the default. Therefore, default it before converting it to a number as follows:

moneyAmountRequired: (payload.root.MoneyAmountRequired default "0") as :number{format: "0"}

Hope this will answer your question about the default 0 not working.

score -1 · Answer 8 · answered Mar 07 '17 at 10:15

-1

Use this for

%dw 1.0

%output application/json

{ value : moneyAmountRequired: floor payload.root.MoneyAmountRequired as :number default 0 }

answered Mar 07 '17 at 10:15

Zahid

59
10

Mule dataweave: convert decimal to an integer

8 Answers8

%var regex = /(.\d+?)0+\b/

%output application/json