How to delete columns based on criteria in column title
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
FionnGodwin
5 - Atom
11-08-2021
07:59 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I want to delete columns in my table based on the name of the column. There are lots of columns with names like: accountgroup1, accountgroup2, accountgroup3....i want to removed these.
Trying to use the Dynamic Select tool with the function !StartsWith(column, "accountgroup").
How can i get a formula to run through all the columns and deselect the ones that start with "accountgroup"?
Labels:
- Labels:
- Input
2 REPLIES 2
kenkie
6 - Meteoroid
11-08-2021
09:05 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello Fionn, can you try this one? !StartsWith([Name], 'accountgroup')
benholland
5 - Atom
05-16-2023
05:46 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I had the same issue, and used your solution @kenkie which worked. So although you don't have a reply from FionnGodwin, just wanted to say your solution is correct and works. Thanks 👍
