ERROR: Assign: Input string was not in a correct format

mazlumkacar · March 17, 2020, 12:40pm

Hi all,

I am getting this error when i try to convert a variable string to double or string to int32.

How may i solve it?

Values that it try to convert are :

vishal.kp · March 17, 2020, 12:44pm

@mazlumkacar That is because you have the character , in your cell. Replace the comma and then try to convert it.

mazlumkacar · March 17, 2020, 12:45pm

But if i replace, how to convert it true? How may i replace it?

vishal.kp · March 17, 2020, 12:47pm

Can you display what you have inside the assign activity. i.e inside the convert function.

mazlumkacar · March 17, 2020, 12:48pm

Convert.ToInt32(sapfiyat)

or

Convert.ToDouble(sapfiyat)

vishal.kp · March 17, 2020, 12:50pm

Do Convert.toint32(sapfiyat.replace(“,”,“”))

mazlumkacar · March 17, 2020, 12:54pm

now i got the same error not first one but for second one.

The value is “1” in the excel. Why is that getting this error?

Palaniyappan · March 17, 2020, 1:01pm

Kindly use the expression like this
Convert.Toint32(Strinput.ToString.Trim.Replace(“,”,””))

Topic		Replies	Views
Conversion from string to integer formats Activities excel , studio , error	5	2395	October 28, 2020
Assign: Input string was not in a correct format Help activities , error , data_manipulation	2	1199	November 30, 2019
VINAY Assign: Input string was not in a correct format Academy Courses excel , activities	5	1163	November 17, 2022
Assign: Input string was not in a correct format issue Help activities	3	9300	April 24, 2019
String to Double (Input string was not in a correct format.) Help datatable , activities , data_scraping , error	12	6164	December 19, 2019