How to add values in different row of a datatable while all values are present in a single row seprated by " "

[ssinha1 (Ssinha)]

Hi,

I want to add values in different rows of a data table which are present in a single row.

input file
Account Num
123456 234567 345678

expected output.

Thank you in Advance.

[Davuluri_Manikumar]

Hi @ssinha1 ,
You can use spilt method and try with for loop to add values to the data table .
in your case it will be
Array=String.Spilt(" "c)
the use for loop to add it
Cheers

[Darshit_Vekariya]

@ssinha1

I want to add values in different rows of a data table which are present in a single row.

input file
Account Num
123456 234567 345678

Use This

Variable List{String}

string[ ] values = input.Split(’ ');

After Using For Each Loop to Perform By Your Choice

Cheers ,Thanks

[sasi_poosarla (sasi p)]

@ssinha1

Split(dt_Build(0)(0).Tostring," ").Select(Function(x) dt_Build.Clone.Rows.Add(New Object(){x})).copytodatatable

Cheers!!