How to Convert String field into int32

I got data from browser in variable Extract datatable, using filter option i can maniculate only text field by using filter database.i can’t able to use < or > because it is a string.

I use assign activity to fetch data WIID fileld.
Select statment is “ExtractDataTable.Select(“WIID<‘500000’”).CopyToDatatable”

Iam getting an runtime error “WIID field not found”.
Can anyone please advise?

Can you try using this
ExtractDataTable.Select(“Int32.Parse((WIID))<Int32.Parse(‘500000’)”).CopyToDataTable

Check this below code, @NC_Vignesh
ExtractDataTable.Select(Function(x) Cint(x(“WIID”).ToString.Trim) < 500000).CopyToDataTable

ExtractDataTable.AsEnumerable.Where(Function®( Convert.ToInt32(r(“WIID”).ToString)< 500000 )).CopyToDataTable

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