I have a CSV with three colums.
In a colum named “Additional Discounts” i have values that are either xx , xx% or 0.xx
for each of those cases i want to format the row to be xx
Can anyone help ?
I tired an assign with : CorrectedDiscount = Convert.ToInt32(row(“Additional Discount”).ToString)*(100)
but i get an error: Assign : Input string was not in a correct format.