Hi Guys, Datatable : Invoice AMOUNT 12345 9,897.58325 12346 5,180.56780 12347 3,700.73930 12348 3,885.09340 12349 53,197.30534 12350 49,023.15789 I’m using a select statement to get an array output, however, I’m having difficulty setting a format for decimal. var_temp_dt.AsEn…

Hi @Dmitri00007 Try this expression (From D in Dt.AsEnumerable Let x=d(0).ToString+"_"+Convert.ToDouble(d(1).ToString).ToString("#.##") select x).ToArray [image] Regards Sudharsan

Setting Decimal Format in select statement

Help Studio

RajKumar_DC (RajKumar Durai) January 5, 2023, 7:54am 5

Hi @Dmitri00007

Check this code

dt.AsEnumerable.Select(Function(x) x("Invoice").ToString+"_"+Convert.ToDouble(x("AMOUNT").ToString).ToString("#.##")).ToArray

Thanks,

Topic		Replies	Views
DataTable.Select correct syntax for string / double / decimal objects Studio studio , question , variables_management	1	1416	June 22, 2021
Linq to math round 3 decimals column of string Studio studio , linq	7	3245	May 21, 2022
Studio Question on Query Studio studio , question , activities_panel	8	815	July 16, 2021
Need help/advice in resolving a select from datatable Studio studio , question , properties_panel	4	1363	February 10, 2022
Oledb select query Studio excel , studio , oledb	18	1374	July 21, 2023

Setting Decimal Format in select statement

Related topics