Convert string columns to numeric and sort datatable on this column

Learning & Development Programs Reboot Your Skills 2021
, ,
1

Hi everyone,

I have a excel file, i have to sort “price” column highest to lowest but the column is in Text format.
How to convert string to numeric of all columns…
my excel screenshot.

Delimit
Delimit501×689 8.23 KB

Thank you…

2

@saikumar
In case of the default activities as Sort Table, Sort DataTable are not working as expected giv a try on following:

  • read in excel with write range into a datattable (e.g. Variable: dtData)

  • assign activity:
    left side: dtSorted (Datatype: DataTable)
    right side:

    dtData.AsEnumerable.OrderByDescending(Function ( r ) CDbl(r(YourColNameOrIndex).toString.Trim)).CopyToDataTable

2 Likes
3

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