Update tool Configuration in Macro

Hi all

I've built a macro which uses the text to columns tool. I'd like to be able to configure the selection/deselection of the 'advanced options' of this tool (e.g. skip quotes in quotes) through the configuration of the parent macro.

Does anybody know how this could be done? When I attach the action tool to the text to columns, there doesn't appear to be an action corresponding to this function.

Thanks

Macros

Accepted answers

Bob_Blackey

Thanks @DataBlender, I learned a few things today :-)

The attached workflow shows you how to do it. There are of course other methods but this works.

The key is the formula in the action:

You can use the formula builder (...) button to help build the formula.

The formula uses IIF functions to build the value.The surprise was that it requires a string to work, hence the ToString. If you use a numeric value it doesn't work.

Cheers,

Bob

Macro-Text to Columns.yxwz

All comments

Aguisande

Hi @DataBlender,

Have you tried adding a GroupBox to the Macro interface, put all the interface controls you want to hide/show, and a CheckBox inside the macro with the "Collapse Group when Deselected" ticked?

This will do the job.

Bob_Blackey

I couldn't find this in the help anywhere, but I had a hunch and tested with the debug mode.

You have to change the value in the flag field.

A value of :

1 - Checks The Ignore Delimiters in Quotes

2 - Checks the Ignore Delimiters in Parenthesis

8 - Checks the Ignore Delimiters in Single Quotes

16 - Checks - Skip Empty Fields

32 - Checks Ignore Delimiters in Brackets

If you want a combination you add the values :

ex.

40 gives you Single Quotes and Brackets

41 Single Quotes, Brackets and Quotes

Cheers,

Bob

DataBlender

Thanks @Bob_Blackey, does that also mean that to convert the user input (which will look the same as the check boxes in the original tool) into something that can update the tool, I'll need to assign a value to each option, sum them up and then update the value accordingly?

I guess the values are sequential powers of 2 to avoid ambiguity when summing them up to establish the options to be selected.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703