To sort the numbers that have 4 digits

Help StudioX
,
1

I have a column in Excel in which there are numbers of different formats and I need to sort the numbers that have 4 digits. How can this be implemented in StudioX?
image

2

Hi @teslyak9437

Try this

image
image870×580 26.7 KB

(From row In dt.AsEnumerable()
 Where row.Field(Of Double)("ColumnName").ToString().Length = 4 AndAlso IsNumeric(row.Field(Of Double)("ColumnName").ToString())
 Order By Convert.ToDouble(row.Field(Of Double)("ColumnName"))
 Select row).CopyToDataTable()

Input:

image

Output:

image

Regards,

3

It must to implemented in StudioX

4

@teslyak9437

Same as studio only

image
image854×604 29.4 KB

(From row In DT.AsEnumerable()
 Where row.Field(Of Double)("ColumnName").ToString().Length = 4 AndAlso IsNumeric(row.Field(Of Double)("ColumnName").ToString())
 Order By Convert.ToDouble(row.Field(Of Double)("ColumnName"))
 Select row).CopyToDataTable()
5

I must to delete this value

6

@teslyak9437 Can you clarify more about the input & output?

Must delete the value means?

Regards,
Ajay Mishra

7

@teslyak9437

How about the following?

image
image854×604 31.6 KB


Dim rowsToDelete = (From row In dt.AsEnumerable()
                    Where row.Field(Of Double)("ColumnName").ToString().Length = 4 AndAlso IsNumeric(row.Field(Of Double)("ColumnName").ToString())
                    Select row).ToList()


For Each rowToDelete In rowsToDelete
    dt.Rows.Remove(rowToDelete)
Next

image
image909×266 9.94 KB

Output:

image

Regards,

8

It must to implemented in StudioX

9

image

10

@teslyak9437

It is in studiox only please check

11

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