Nested dollar expansion

[martynlloyd]

I have created a function:

Set fReduceName = Replace(Replace(Replace(Replace(PurgeChar(Lower(PurgeChar($1,' ,./-_+()£$!*')),chr(39)), 'plc',''),'ltd',''),'limited',''),'&','and');

This is great, works and makes the scripts much neater.

I now want to use the result of the first function inside another function, in the same Load segment.

Set fOrganisation = SubField( ApplyMap('Organisations', $1,'Unknown'), ';', $2);

where $1 is the result of fReduceName.

The first parameter is the Organisation Name in both functions

Regards,

Marty.

[rubenmarin · Accepted solution]

Hi Martyn, try with:

Set fOrganisation = SubField( ApplyMap('Organisations', $(fReduceName($1)),'Unknown'), ';', $2);

You need to call the variable with the parameter, it will pass the parameter to the inner variable