Hello Everyone, I have a data table with 6 columns I need to split the First Column values and add those values in to rest 5 Columns. Sample Excel Data [Capture1234] Required Output [image] Thanks in advance

You can read in the excel with read range addHeaders Option is ticked on - dtData dtCleansed = dtData.Clone then loop over dtData use the first column value, Split with regex all multiple spaces and add it as rowArray to dtCleansed Add Datarow Activitiy - Datable: dtCleanse - RowArray: System.…

Spilt Column Value in data table and add to other columns by using LINQ

Help Studio

kumar.varun2 (Varun Kumar) July 4, 2022, 1:26pm 8

Hi @nitesh.s

I have implemented the @ppr aaproach
Please have a look

Output

SplitColumns.xaml (7.6 KB)

3 Likes

Forum Engagement Daily Reports

Topic		Replies	Views
Split cell values in datatable using linq Forum datatable , excel , question	3	1174	June 22, 2022
Splitting a single string in one column Studio studio , question , designer_canvas	19	1411	July 17, 2021
Split numbers in a web extracted datatable and separate columns Help datatable , studio , data_scraping , question	6	994	April 24, 2020
How do I split column values in a data table with regex? Help studio	4	1840	May 24, 2019
How get data from data table if exist and regex the value with LINQ Forum activities , studio , question	5	930	August 30, 2022

Most Active Users - Yesterday
ashokkarale
anjani_priya
Dheerendra_vishwakarma
Parvathy
Aakash_Singh_Rawat
Luis_Fernando
bjorn2390
neco
pere
Shiva_Nikhil
More details...

Spilt Column Value in data table and add to other columns by using LINQ

Output

Related Topics