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

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 :

image

1 Like

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

2 Likes

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

@vishal.kp
@Palaniyappan

1 Like

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

1 Like

@vishal.kp

Convert.ToInt32(sapfiyat)

or

Convert.ToDouble(sapfiyat)

Do Convert.toint32(sapfiyat.replace(",",""))

3 Likes

@vishal.kp

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?

1 Like

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

Cheers @mazlumkacar

2 Likes

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