Datable Column as string. Need as Integer

[Em126351]

Hi

Hoping someone can help me with this please?

I have the following datatable - Search Results DT.

This has pulled through where all columns are string. I need column “Days_Open__c” to be an integer so I can use the filter datatable activity.

I can’t seem to make sense of anything I have read in the forum for this issue but it has been asked a few times.

Does someone have a quick fix that will mean I don’t have to create a new datatable?

[Pradeep_Shiv]

Hello @Em126351

You can go through this post,

Convert to numbers

@Jarzzz copy and paste is working …i need to convert a particular column values as numbers[excel-error-convert-number] Attached is the required activities…i have to the same with uipath … I have tried to send hot keys but its not working

[ppr (Peter Preuss)]

Cint(row(“YourColNameOrIndex”).toString) is pulling out the value as Integer
using it for filtering can be done with the datatable.Select( … method or with LINQ

[Em126351]

@Pradeep_Shiv this is for excel so no use. I’m using a datatable.

@ppr you’re approach seems more like what I’m looking for, however I’m not that experienced. I have no idea about LINQ… Can you dumb that down any more?

[supermanPunch (Arpan)]

@Em126351 Maybe this is what you’re looking for :

UiPath Marketplace | Error

[ppr (Peter Preuss)]

I would suggest to start with the select method, could be easier to start with:

DataTable.Select Method (System.Data)

https://www.csharp-examples.net/dataview-rowfilter/

here the part Convert Function like: “Convert(total, ‘System.Int32’) = 2”

In Linq it would look like:

(From d In YourDataTableVar.AsEnumerable
Where CInt(d(YourColNameOrIndex).toString.Trim) = 5
Select d).CopyToDataTable

with the assumption that the filter result is not empty otherwise CopyToDataTable throws an exception. If there is a risk of empty result then it can be handled as here:

Select item in datatable

@Maroua302 check if one column of my datatable contains for example the name “john” can be interpretated in many directions: True if any row contains John in columnA dtData.AsEnumerable.Any(Function (x) x(“ColumnA”).toString.Contains(“John”)) *return all john rows dtData.AsEnumerable.Where(Function (x) x(“ColumnA”).toString.Contains(“John”)).toList dtData.Select(“[Name] LIKE ‘%john%’”).toList About the datarows and Copytodatatable: we can also expect that a filter result can be empty…

[Em126351]

@ppr thanks for sending that over. I’ll be honest I haven’t used it. But its definitely helped me make more sense of it. In the end I have just added a new int32 data column, then in a for each row, taken the value from the string column, converted in to int and added into the int32 column. I’ll just tidy it up and remove the string column. Not ideal for big datatables I guess but I’m only expected a few lines of data.