6 Replies Latest reply: Jan 9, 2018 3:10 PM by Burak Ersoy RSS

    Variables in Load Editor and CHR(39)

    Burak Ersoy

      Dear All,

      Hope you are doing great and I will appreciate it if you can help me with this problem. I created a variable in a sheet named as vBetweenRolling5 and defined as

      
      
      
      
      
      
      {"$(= '>=' & FirstDayMonthRolling5 & '<=' & LastDayMonthRolling5)"}
      

       

      Everything was working as it suppose to; however, I wanted to transfer all my variables to data load level. Therefore, I created the load script as

      
      
      
      LET vBetweenRolling5 = '{"$(= ' & CHR(39) & '>=' & CHR(39) & ' & FirstDayMonthRolling5 & '& CHR(39) & '<=' & CHR(39) & ' & LastDayMonthRolling5)"}';
      

       

      However, the variable was created in debug as

      
      
      
      {""}
      

       

      Please see the screenshot:

      Capture.PNG

      Any suggestions?

       

      Thanks a million in advance!