string to number format

(0) Share

Report

Posted on by arcado

320 Moderator

Hi,

I have a list columns are string type (Component are like 58,34 ; 45,3 )I have to add them together. Whenever I transfrom string to float It will become like 5834 and 453 how can I fix that?

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (2)

Verified answer

shoog 2,164 on at

Like (0)

Report

This indicates a mismatch with decimal seperators. Either replace , with . in your source or include that in an expression replace(yourstring, ',','.')

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com on at

Like (0)

Report
Hi @zbegumdost,

Do you want to convert a string number into a float number?

I think the key to your issue is the delimeter you used is a comma, you could firstly replace the "," comma with the dot ".".

Please try as below:

float(replace(items('Apply_to_each_2')?['Column'],',','.'))

Was this reply helpful? Yes No