split function

(0) Share

Report

Posted on by Vstar19

381

Spoiler (Highlight to read)

[
{
"[KPI]": 1,
"[Value]": 0.9365079365079365,
"[Goal]": 0.9
}
]

Hello.

I can i split the above code so it returns me just the Value of 0.9365079365079365 and to return it as 0.93650793 (9 decimal places)

I have the following code
split(trim(split(string(outputs('Value')),':')[2]),'}')[0]

But this returns it to me as 0.9365079365079365,"[Goal]" - not sure what i am doing wrong. I just want 0.93650793

Thanks

[{"[KPI]": 1,"[Value]": 0.9365079365079365,"[Goal]": 0.9}]Hello. I can i split the above code so it returns me just the Value of 0.9365079365079365 and to return it as 0.93650793 (9 decimal places)I have the following code split(trim(split(string(outputs('Value')),':')[2]),'}')[0]But this returns it to me as 0.9365079365079365,"[Goal]" - not sure what i am doing wrong. I just want 0.93650793Thanks

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

Chriddle 8,443 Super User 2025 Season 2 on at

Like (1)

Report
With split() you convert a string into an array.

Your data seems to be an array (or a JSON string that can be converted into an array with function json())

first(outputs('Compose'))['[Value]']

You can use formatNumber() to restrict the decimal places.

Was this reply helpful? Yes No
Perumal 604 on at

Like (0)

Report

You can utilize this expression to retrieve a value with precisely 9 decimal digits:
substring(string(outputs('Compose')[0]['[Value]']), 0, add(indexOf(string(outputs('Compose')[0]['[Value]']), '.'), 9))

Was this reply helpful? Yes No