Hello together, i have the following datatable (here only an example - 60000+ rows): column 1 column 2 A 1000 B 2000 C 3000 I want to have the following: column 1 column 2 column 3 A 1000 10 B …

Hi @PeCour Assign TestDB = DT.Clone Add a column (“Column3”) to TestDB using the Add Data Column Actvity Use below LINQ TestDB = ( From row In DT.AsEnumerable() Let a = row("Column3").ToString.Substring(0,2) Select TestDB.Rows.Add({row("Column1"), row("Column2"), a}) ).CopyToDataTabl…

How to? New datatable column as substring of existing column without for each

Help Activities

supermanPunch (Arpan) August 26, 2022, 11:00am 3

Hi @PeCour ,

Maybe you could also achieve the same result with DataColumn.Expression property as shown below :

DT.Columns("OutputColumnName").Expression = "SUBSTRING(InputColumnName,1,2)"

1 Like

Topic		Replies	Views
Copying Substring of a column to another column? Help	5	1885	July 2, 2019
I want Substract one column A Date from an another column B in same datatable using linq and save result to third column C Studio	1	1791	June 25, 2021
Substring a column Without looping Help	14	5134	December 14, 2019
Replace one value with another in a specific column Community question , community	12	2712	September 27, 2022
LINQ syntax to update each cell value for a column of a DataTable Activities activities , question , other	4	1613	November 5, 2023

How to? New datatable column as substring of existing column without for each

Related topics