Get columns from datatable

[abdel (sa)]

hi,

i had the following output datatable: Column0,Column1,Column2,Column3,Column4,Column5,Column6,Column7,Column8,Column9,Column10,Column11,Column12,Column13\r\n0,3,0,5,8,3,2,5,8,1,2,8,1,2\r\n

i had to extract 0,3,0,5,8,3,2,5,8,1,2,8,1,2, anybody had an idea

[balupad14 (Balamurugan)]

HI @abdel,
Can you try this. yourText.Split(Environment.NewLine.ToArray, StringSplitOptions.RemoveEmptyEntries). Hope it works!

Regards
Balamurugan

[abdel (sa)]

Thank you,
what is the type of return? string ?

[balupad14 (Balamurugan)]

Hi @abdel,
Yes. It will return string array…

Regards
Balamurugan

[abdel (sa)]

i had used it but :

[balupad14 (Balamurugan)]

HI @abdel,

Can you try Extract(1).ToString
If possible, can you attache the xml please ?

Regards
Balamurugan

[abdel (sa)]

extractGTIN.xaml (8.0 KB)

[balupad14 (Balamurugan)]

Hi @abdel
xl sheet is missing…

[abdel (sa)]

i sent it by msg

[balupad14 (Balamurugan)]

Yes i got it.

[MAHESH1 (MAHESHKUMAR JV)]

@abdel

You can directly get it by using
string a =string.Join(“,”,DataTableVariable.R ow(0).ItemArray)

Regards,
Mahesh

[abdel (sa)]

it does not work

[balupad14 (Balamurugan)]

HI @abdel,
When you use this “Extract(1).ToString” , you are getting the output. below the screen i have attached.

Regards
Balamurugan.S

[balupad14 (Balamurugan)]

HI @abdel,
Here I have attached the xml also.

extractGTIN.xaml (8.3 KB)

Regards
Balamurugan