Convert text column to number in uipath

[Sheikh_Mustafa]

i have lookup the column with text format due to text format i am unable to calculate with assign activity kindly define how to convert column to numeric

[Shiva_Nikhil]

@Sheikh_Mustafa

Cint(yourvariable)

try this with place it in the string variable

cheers

[ton (Anthony)]

You can add this package:

UiPath Marketplace - BalaReva Easy Data Table Activities

Hi , I have uploaded a package called “Easy DataTable Activities” in UiPath Marketplace. The package contains the below activities. Change Column Data Type - Change the datatype for DataTable by having the option to multiple columns Dictionary To DataTable - Convert the dictionary to DataTable Show DataTable - This activity helps to see the DataTable value and column information. Mainly this is testing DataTable value in the development stage. Here is the video explanation for the p…

It has a ‘Change Data Type’ activity which can convert the Column Type.

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

Hi @Sheikh_Mustafa ,
some ways to convert type of columns
1.You can try by activity
open file send hot key win+r to open run
type into file path
send hot key enter to open
click column need change type
click type, type into name of type
send hot key enter
send hot key ctrl+s
to save file
2. you can find invoke vba code
regards,