Hi all, I’m having an issue formating a data column as numeral with one decimal digit. The datatable has no headers and I need to convert the column index 3, which is as general now, to number. The point is that I don’t want to use Excel activities but instead manipulate the data directly in the …

HI @roberto.piccolli hope it will help for you inside the loop you can use this condition = String.Format(“{0:F1}”, cint(CurrentRow(0))) [image] can see the output [image]

Hi Check with this thread for your scenario [image] Change Data table column type String to Integer Studio Hi @sankar.mayilsamy How about this expression? (From d In DtBuild.AsEnumerable Where CInt(d(1).toString.Trim)>=70 Select d).CopyToDataTable Note → Need to give …

Hi @roberto.piccolli Yes its possible and can you share the input and expected out

[image] roberto.piccolli: but instead manipulate the data directly in the data table. Is it possible? Yes in general possible. When the data column Datatype is matching for the new value, then we can convert e.g. within a for each row and and assign Activitiy When the data column Dataty…

I need to convert the column index 3 to number with one decimal digit [image] So the expected result would be 2.0; 3.0; 5.0 and so on

let me know its working or not for you @roberto.piccolli

Convert datatable general value to number

Help StudioX

Palaniyappan (Palaniyappan P ) September 15, 2023, 9:49am 2

Check with this thread for your scenario

Cheers @roberto.piccolli

Topic		Replies	Views
Covert Datatable Column from character to numeric Activities excel , activities , question	18	2011	January 20, 2022
Convert String To Int in DataTable Studio studio , question , find_references	9	5436	September 20, 2021
Is there a way to convert datatable's row datatype? Activities excel , activities , studio	8	1436	May 26, 2022
Change Data table column type String to Integer Studio studio , question , activities_panel	10	5230	September 20, 2022
Datable Column as string. Need as Integer Help	6	7823	August 10, 2020

Convert datatable general value to number

Related topics