remove values using column

[shahnawaz_khan]

Hi everyone,

Could you please let me know how to remove all IDs except those that start with "T"? Any IDs that don't meet this criterion can be removed.

Input
date	ID	product
05-Nov-24	1748	Machine1
05-Nov-24	3068	Machine2
05-Nov-24	3770	Machine3
05-Nov-24	4150	Machine4
05-Nov-24	4609	Machine5
05-Nov-24	5588	Machine6
05-Nov-24	6578	Machine7
05-Nov-24	6993	Machine8
05-Nov-24	T279642	Machine324
05-Nov-24	T279646	Machine325
05-Nov-24	T279652	Machine326
05-Nov-24	T279702	Machine327
05-Nov-24	T279733	Machine328
05-Nov-24	T279835	Machine329
05-Nov-24	T279839	Machine330
05-Nov-24	T280493	Machine331
05-Nov-24	T280495	Machine332
05-Nov-24	T280496	Machine333
05-Nov-24	DG35972	Machine66
05-Nov-24	DG35979	Machine67
05-Nov-24	DG36504	Machine68
05-Nov-24	DG37054	Machine69
05-Nov-24	DG37055	Machine70
05-Nov-24	DG37498	Machine71
05-Nov-24	DG37519	Machine72
05-Nov-24	DG37524	Machine73
05-Nov-24	DG37709	Machine74

Output
date	ID	product
08-Nov-24	T279642	Machine324
08-Nov-24	T279646	Machine325
08-Nov-24	T279652	Machine326
08-Nov-24	T279702	Machine327
08-Nov-24	T279733	Machine328
08-Nov-24	T279835	Machine329
08-Nov-24	T279839	Machine330
08-Nov-24	T280493	Machine331
08-Nov-24	T280495	Machine332
08-Nov-24	T280496	Machine333

[Qiu · Accepted solution]

@shahnawaz_khan 
there is a formula "Startwith"

Try a Filter tool with expression

Startwith([ID],"T")

[Bobbyt23 · Accepted solution]

Another option would be a filter on LEFT([ID],1) = "T"

[shahnawaz_khan]

Thank you, this is solved now.😊