How to delete all columns contaning a specific text?

[richleeb2]

I have a table where I need to delete all the columns that contain the word "status" or "associated" in the header.  How do I do this?

[nagakavyasri]

@richleeb2 Try this:

[richleeb2]

Hi,

I tried this but the output formatting came out wrong.  My original table has 11 records and 1093 columns.

[Raj]

use dynamic select tool
you can refer to the example attached.

[Raj]

Dynamic select >- select by formula

!Contains([Name],"status") or !Contains([Name],"associated")

[nagakavyasri · Accepted solution]

@richleeb2 Try this: