Hi experts, Quick question from my side, is it possible to use a linq statement to round all values in a string column to 3 decimals points? I have already changed the commas to points using a link statement but now I need to format it to meet our input requirements. For each row is not a possibili…

Hi Palaniyappan, Also made the columns dynamic, thanks for the help! See code below: dtTest.AsEnumerable().ToList().ForEach(Sub(row) If String.IsNullOrEmpty(row(“Risiko aktuell ab”).ToString) Else row(“Columname”)=DateTime.ParseExact(row(“Columnname”).ToString,“MM/dd/yyyy 00:00:00”,System.Globa…

Linq to math round 3 decimals column of string

Help Studio

Palaniyappan (Palaniyappan P ) May 21, 2022, 12:43pm 5

Fine
Got to see a thread with similar scenario
Have a view on this

Cheers @dyuonn.bakker

1 Like

Topic		Replies	Views
How to round the datatable values? Studio studio , question , workflow_diff	1	199	April 18, 2024
Regarding the decimal points Activities excel , activities , question	3	955	December 30, 2022
Column values to 2 decimal places Academy Feedback lp_business_analyst_fnd	3	1224	May 9, 2023
Unable to Truncate decimal places from decimal values of a column in Datatable Studio datatable , studio , question	5	3817	May 11, 2020
Convert data in columns into having 2 decimal places (possibly using LINQ) Studio datatable , excel , studio , question , activities_panel	17	4754	April 21, 2022

Linq to math round 3 decimals column of string

Related topics