Hi everyone, My requirement is to remove everything after the occurrence of the first comma in an entire column of a datatable. Please find the input and expected output below. My data table is huge and hence I cannot use for each loop. Please provide a code to do the same. [image] Thanks

@ammohan , Please find the below code and use in invoke activity DT.asenumerable.Tolist.Foreach(Sub(r) r(“Input”)=r(“Input”).tostring.split(","c).first.tostring).Copytodatatable

Remove everything after first comma in an entire column of a datatable without for each

Help Activities

system (system) Closed December 17, 2022, 12:36pm 10

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.

Topic		Replies	Views
Removing character from column Help datatable , excel , studio	19	4083	December 12, 2019
Remove all commas from datatable Activities activities , question , document_processing	2	3111	April 12, 2021
Remove first 2 characters from all values in a column Academy Feedback lp_developer_fnd	7	586	July 13, 2023
Apply the same method to the entire datatable column Studio activities	4	845	March 17, 2021
Ouput DataTable how to remove the comma Help	1	1689	May 23, 2020

Remove everything after first comma in an entire column of a datatable without for each

Related topics