Hi! I want to remove a column with blank and certain characters from the data table. The blank code came from someone else’s question. I would like to know the code to add a specific character here. :thinking: :thinking: Is there a Superman who can help you? [help]

I want to remove columns with blanks and certain characters in my data table

Yoichi (Yoichi) February 28, 2022, 6:52am 2

Hi,

Your code seems remove rows…
Anyway, can you try the following expression?

BBBB = AAAAA.AsEnumerable.Where(Function(x) Not (String.IsNullOrEmpty(x("Jan").ToString) OrElse x("Jan").ToString.Contains("KEYWORD"))).CopyToDataTable()

Regards,

3 Likes

Delete rows containing blank values by deleting duplicate values in item A in the data table, leaving only those with higher values in item B

Forum Engagement Daily Reports

Topic		Replies	Views
I want to remove columns that contain blanks in the data table and values less than 100 StudioX datatable , activities , studio , studiox , question	3	985	March 1, 2022
Delete rows containing blank values by deleting duplicate values in item A in the data table, leaving only those with higher values in item B StudioX datatable , studio , studiox , question	5	1050	March 7, 2022
How to remove character in a data table Forum datatable , excel , question	5	2890	March 29, 2021
Linq Activities datatable , excel , activities , question , how-to-delete-empty-row-and-rows-contain	5	915	March 10, 2022
Linq Query -- Help Studio datatable , excel , uiautomation , studio , question , activities_panel , linq , linq-query	4	1762	January 19, 2022

Most Active Users - Yesterday
Anil_G
ashokkarale
jinal.shah
Gautham_Pattabiraman
postwick
chandreshsinh.jadeja
vrdabberu
Ajay_Mishra
sven.wullum1
Vyshnavi_Nalumachu
More details...

I want to remove columns with blanks and certain characters in my data table

Related Topics