I need to delete a series of columns of a vector attribute table inside GRASS before starting further processing. I know I can use
v.db.dropcolumn map=vector@PERMANENT columns=col1,col2,col3
But if I have many columns (say 100), then it seems unrealistic to write so many names in the script. Even clicking it inside the module GUI can be tricky and erroneous.
Is there a way I can use wildcards to match column name pattern to select columns and get it deleted at one go? I have tried
v.db.dropcolumn map=vector@PERMANENT columns=col*
But it does not work. Any suggestion? or getting rid of multiple columns can be done in an alternative way inside GRASS?
I am on Windoze 7 with GRASS 7.4 and using Python 2.7 for scripting.