1 Reply Latest reply: Jan 26, 2017 12:58 PM by Ruben Marin RSS

    Nested dollar expansion

    Martyn Lloyd

      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