Format data from a source in string to our own format

[shiva1020243]

Hi team,

can somebody pls help me?

i have an interest rate coming from a source is "00550" and "02000"

How can I convert it to 0.550 or 0.550?

02.000 or 2.000?

Thanks

[richie]

Hey @shiva1020243,

Can you provide more info to clarify?

When you say "source", are you using the datasource functionality? If "yes", how are you using it?
Or, is the numerics a value in a response?

Cheers,

Rich

[TNeuschwanger]

Hello @shiva1020243 

Here is some groovy script code that can do what you request.  Given your ambiguous requirement, I made best guess at a response...   🙂  

There are two sections of the code that are identical just to show different originating source values and their outcome.

Regards,

Todd

import java.text.DecimalFormat;

df = new DecimalFormat("#0.000");


interestRateStr = "00550";
interestRateInt = interestRateStr.toInteger();
interestRateFloat = interestRateInt / 1000;
log.info "interestRateFloat=$interestRateFloat";
finalValue = df.format(interestRateFloat);
log.info "finalValue=$finalValue";

interestRateStr = "02000";
interestRateInt = interestRateStr.toInteger();
interestRateFloat = interestRateInt / 1000;
log.info "interestRateFloat=$interestRateFloat";
finalValue = df.format(interestRateFloat);
log.info "finalValue=$finalValue";

[sonya_m]

Thanks everyone!

Hi @shiva1020243, does the advice from the Community help? Please let us know.