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

       

      Regards,

      Marty.