how to split 1 collection into 2 by column name

[sumire]

Hi,

I want to split a collection whose column name starts with "A-" and a collection whose column name doesn't start with "A-".
VBO 'Delete Column' does not allow wildcards or regular expressions in column name.
Please tell me good way.

Thanks,

------------------------------
Mitsuko
Asia/Tokyo
------------------------------

[VivekGoel]

Use Utility-Collection Manipulation --> Delete Field. It supports wild card.

------------------------------
Vivek Goel
RPA Architect
Asia/Singapore
"If you like this post, please press the "Recommend" Button.
------------------------------

[sumire]

I did but it doesn' work

------------------------------
Mitsuko
Asia/Tokyo
------------------------------

[VivekGoel]

My bad.. this works only if the column is empty. Let me write a custom code and get back to you.

------------------------------
Vivek Goel
CoE Lead Architect
Asia/Singapore
"If you like this post, please press the "Recommend" Button.
------------------------------