cancel
Showing results for 
Search instead for 
Did you mean: 

Collection Query - deleting multiple columns

JamesWilliams
Level 4
Hi, I've added an Excel sheet as a collection and have been successful in deleting one undesired column using the Collection utility. Would somebody be able to give me some pointers on how I could use a multiline expression to delete several columns? Is it possible? e.g. I want to delete "Address Line 1" & "Address Line 2" & "Address Line 3" from the collection what would the correct syntax be in the expression editor? Thanks
1 REPLY 1

John__Carter
Staff
Staff
It's not possible with the current utility object, but it is possible to write more .Net code to do that. However, it would be quicker just o call the utility3 times.