Column values to 2 decimal places

[TyraS (Tyra)]

Hi, i have a dt with some columns that are in string.
e.g.
1210.1
12
1032.12

Is there any way to convert the whole column value to 2 decimal places, which doesnt use the for each row method?

[vishal.kp (vishal)]

Hi @TyraS ,

Check this out:

Convert data in columns into having 2 decimal places (possibly using LINQ)

Hi, I want to change the data gathered from a csv file into having 2 decimal places at the end. This is because I have to compare them with an extracted datatable, which holds the same value but with proper 2 decimal places because it is based on the currency format (but I don’t think it is saved as such). For example: Extracted Datatable: 45.80 1232.60 CSV Datatable: 45.8 1232.6 The amounts with no cents at the end have no problem though. If there’s no way to exclude whole numbers like …

Regards,

[Anil_G (Anil Gorthi)]

@TyraS

You can use compute to do this using assign activity

dt = dt.Compute("Round([ColumnName], 2)", "")

cheers

[Srini84 (Srinivas)]

@TyraS

Check below for your reference

Convert data in columns into having 2 decimal places (possibly using LINQ)

@beepboop CurrentRow(0).ToString.PadRight(5, CChar("0")) PadRight is the string method that add 0s or spaces or characters etc towards right. 5 is the total length of the input string 0 is the one that adds toward right, CChar is the one that is converting the 0 to char type Ex: 45.2 - It adds 0 at the end - 45.20 49.27 - It doesn’t add anything here Use below doc for ref

Hope this will help you

Thanks,
Srini