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

ammohan (Ammohan) December 13, 2022, 10:33pm 6

Hi @muhamed_fasil

I am getting the following error while using the code in invoke code.

Can you please help me to resolve it?

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