4 Replies Latest reply: Apr 11, 2012 5:32 AM by Miguel Angel Baeyens de Arce RSS

    How to qualify a String?

    Peyman Azimabadi

      Hi all,

      i have a string field, let's assume 'Name':

       

      Name         Age
      ----------------------

      Tobias      20

      Richard     23

       

      i wnat to use the concatenated Names in FOR...EACH...NEXT control.

      my code looks like :

       

      LOAD concat( Name , ',' ) as conNames

      FROM ......

      LET ConNames = Peek( 'conNames' );

       

      result is :

           Tobias,Richard

       

      but this doesn't work in FOR...EACH. i need something like:

      'Tobias','Richard'

       

      i tried :

      LOAD concat( '''' & Name & '''' , ',' ) as conNames

      but it doesn't work and i get error when runing script. i need a way to qualify the string value of Name with '.

       

      Thank you all