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(“,”,””))

system · March 23, 2020, 7:49am

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.

Topic		Replies	Views
Assign: Input string was not in a correct format Help activities , error , data_manipulation	3	1085	December 3, 2019
Assign: Input string was not in a correct format issue Help activities	4	8509	April 29, 2019
Assign : Input String was Not in a Correct Format Activities excel , activities , question	4	1766	July 18, 2022
Error: Input string was not in a correct format Help excel , activities , error	5	6126	June 28, 2017
VINAY Assign: Input string was not in a correct format Academy Courses excel , activities	5	978	November 17, 2022