Convert string columns to numeric

Plareput

New member
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.

3.png


Thank you…
 

EASCalumMuir

Moderator
Staff member
Hi,

Have you tried the sort data table activity? It should work, properties as follows:

1599034530761.png

If it still doesn't work you can Assign it like this:

sortTable = table.AsEnumerable.OrderByDescending(Function ( r ) CDbl(r("Price").toString.Trim)).CopyToDataTable

If AsNumerable is showing as not a member of system.data.datatable then add <AssemblyReference>System.Data.DataSetExtensions</AssemblyReference>
to you XAML file.

Thanks,
Calum.
 
Top