https://community.blueprism.com/t5/Product-Forum/how-to-split-1-collection-into-2-by-column-name/m-p/85532#M36512 Hi,<BR /><BR />I want to split a collection whose column name starts with "A-" and a collection whose column name doesn't start with "A-".<BR />VBO 'Delete Column' does not allow wildcards or regular expressions in column name.<BR />Please tell me good way.<BR /><BR /> <DIV class="media" style="overflow: hidden;"><span class="lia-inline-image-display-wrapper" image-alt="28978.png"><img src="https://community.blueprism.com/t5/image/serverpage/image-id/29107i68CAE16AAD6144A4/image-size/large?v=v2&amp;px=999" role="button" title="28978.png" alt="28978.png" /></span></DIV> <BR /> <DIV class="media" style="overflow: hidden;"> <DIV class="media" style="overflow: hidden;"><span class="lia-inline-image-display-wrapper" image-alt="28979.png"><img src="https://community.blueprism.com/t5/image/serverpage/image-id/29109i272D8E428DA773BE/image-size/large?v=v2&amp;px=999" role="button" title="28979.png" alt="28979.png" /></span> <DIV class="media" style="overflow: hidden;"><span class="lia-inline-image-display-wrapper" image-alt="28980.png"><img src="https://community.blueprism.com/t5/image/serverpage/image-id/29110i39986D91FB64AFD7/image-size/large?v=v2&amp;px=999" role="button" title="28980.png" alt="28980.png" /></span></DIV> </DIV> </DIV> <BR />Thanks,<BR /><BR />------------------------------<BR />Mitsuko <BR />Asia/Tokyo<BR />------------------------------ Tue, 04 Feb 2020 07:12:00 GMT sumire 2020-02-04T07:12:00Z https://community.blueprism.com/t5/Product-Forum/how-to-split-1-collection-into-2-by-column-name/m-p/85532#M36512 Hi,<BR /><BR />I want to split a collection whose column name starts with "A-" and a collection whose column name doesn't start with "A-".<BR />VBO 'Delete Column' does not allow wildcards or regular expressions in column name.<BR />Please tell me good way.<BR /><BR /> <DIV class="media" style="overflow: hidden;"><span class="lia-inline-image-display-wrapper" image-alt="28978.png"><img src="https://community.blueprism.com/t5/image/serverpage/image-id/29107i68CAE16AAD6144A4/image-size/large?v=v2&amp;px=999" role="button" title="28978.png" alt="28978.png" /></span></DIV> <BR /> <DIV class="media" style="overflow: hidden;"> <DIV class="media" style="overflow: hidden;"><span class="lia-inline-image-display-wrapper" image-alt="28979.png"><img src="https://community.blueprism.com/t5/image/serverpage/image-id/29109i272D8E428DA773BE/image-size/large?v=v2&amp;px=999" role="button" title="28979.png" alt="28979.png" /></span> <DIV class="media" style="overflow: hidden;"><span class="lia-inline-image-display-wrapper" image-alt="28980.png"><img src="https://community.blueprism.com/t5/image/serverpage/image-id/29110i39986D91FB64AFD7/image-size/large?v=v2&amp;px=999" role="button" title="28980.png" alt="28980.png" /></span></DIV> </DIV> </DIV> <BR />Thanks,<BR /><BR />------------------------------<BR />Mitsuko <BR />Asia/Tokyo<BR />------------------------------ Tue, 04 Feb 2020 07:12:00 GMT https://community.blueprism.com/t5/Product-Forum/how-to-split-1-collection-into-2-by-column-name/m-p/85532#M36512 sumire 2020-02-04T07:12:00Z https://community.blueprism.com/t5/Product-Forum/how-to-split-1-collection-into-2-by-column-name/m-p/85533#M36513 Use Utility-Collection Manipulation --&gt; Delete Field. It supports wild card.<BR /><BR /> <DIV class="media" style="overflow: hidden; zoom: 1;"><span class="lia-inline-image-display-wrapper" image-alt="28951.png"><img src="https://community.blueprism.com/t5/image/serverpage/image-id/29079i3287920C536AEC5B/image-size/large?v=v2&amp;px=999" role="button" title="28951.png" alt="28951.png" /></span></DIV><BR /><BR />------------------------------<BR />Vivek Goel<BR />RPA Architect<BR />Asia/Singapore<BR />"If you like this post, please press the "Recommend" Button.<BR />------------------------------<BR /> Tue, 04 Feb 2020 08:03:00 GMT https://community.blueprism.com/t5/Product-Forum/how-to-split-1-collection-into-2-by-column-name/m-p/85533#M36513 vivek.kumar.goel 2020-02-04T08:03:00Z https://community.blueprism.com/t5/Product-Forum/how-to-split-1-collection-into-2-by-column-name/m-p/85534#M36514 I did but it doesn' work<BR /> <DIV class="media" style="overflow: hidden; zoom: 1;"><span class="lia-inline-image-display-wrapper" image-alt="28965.png"><img src="https://community.blueprism.com/t5/image/serverpage/image-id/29092i583462B0C2A05858/image-size/large?v=v2&amp;px=999" role="button" title="28965.png" alt="28965.png" /></span></DIV><BR /><BR />------------------------------<BR />Mitsuko <BR />Asia/Tokyo<BR />------------------------------<BR /> Tue, 04 Feb 2020 08:15:00 GMT https://community.blueprism.com/t5/Product-Forum/how-to-split-1-collection-into-2-by-column-name/m-p/85534#M36514 sumire 2020-02-04T08:15:00Z https://community.blueprism.com/t5/Product-Forum/how-to-split-1-collection-into-2-by-column-name/m-p/85535#M36515 My bad.. this works only if the column is empty. Let me write a custom code and get back to you.<BR /><BR />------------------------------<BR />Vivek Goel<BR />CoE Lead Architect<BR />Asia/Singapore<BR />"If you like this post, please press the "Recommend" Button.<BR />------------------------------<BR /> Tue, 04 Feb 2020 09:04:00 GMT https://community.blueprism.com/t5/Product-Forum/how-to-split-1-collection-into-2-by-column-name/m-p/85535#M36515 vivek.kumar.goel 2020-02-04T09:04:00Z