Datatable doubt

Help Studio
, ,
7

In the entire excel how can i remove that symbol

8

in that linq query itself you can use it filtereddt.AsEnumerable().Min(Function(row) Cint(row(“Price”).toString.Replace(“,”,“”).Replace(“$”,“”)))

9

it is still showing the same error

10

we cannot convert empy values / blank but can filter out

give a try at:

(From d in filtereddt.AsEnumerable()
Where Not (isNothing(d("Price")) OrElse String.IsNullOrEmpty(d("Price").toString.Trim))
Select x= Cint(row("Price").toString.Trim)).Min(Function (x) x)

Also we can decide for other strategies like:

  • using the Int32.TryParse() method
  • ordering the values and taking first / last for min and max
11

How can i assign this,can u elaborate

12

Assign Activity
LHS: myMin | DataType: int32
RHS:

(From d in filtereddt.AsEnumerable()
Where Not (isNothing(d("Price")) OrElse String.IsNullOrEmpty(d("Price").toString.Trim))
Select x= Cint(row("Price").toString.Trim)).Min(Function (x) x)
13

what is d i am not good at vb.net thats why i ask

14

it is like a local variable referencing the looped datarow within the LINQ

15

it looks fine when i remove the null values but i have to filter that price and write it into new excel sheet i filter using filter datatable but shows no values how it can be rectified

16

Can you show the filter condition?

17

Screenshot (53)
Screenshot (53)1920×1080 265 KB

by extracting the smallest price it shows 16999 instead of 16,999 i think that the problem

18

do u got it

19

Try
Convert.ToDecimal(cheapest).ToString(“#,##0”) to convert it to original format and then do the filter operation. I think you need to add $ as well in the beginning

20

in the filterdata table?

21

yes…in the value section try to give “$”+Convert.ToDecimal(cheapest).ToString(“#,##0”) as value

22

thank u so much by the by why we use # and ##0

23

this is used to convert it to number format with “,”

24

##0 means what

25

Understanding Number Formatting Codes (Microsoft Excel) check this

1 Like
26

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