7 Replies Latest reply: Dec 21, 2012 8:46 AM by Jefferson Martins RSS

    How to handle single quotes in Inline Load

      I've searched all over the community and have tried different tactics but I can't get this one to work.  The simple inline table below, it's failing due to the single quotes in the "F2" field.  I need those single quotes though.  I've tried different combo's of using double quotes, single quotes, chr(39), [] ... can't figure this out.  I know it's possible.  Can somebody help?  Thanks for anything

       

       

      Example:

       

      LOAD * INLINE [

          F1, F2

          Actuals, sum({$<[Source Name]
      = {'Current View'}>}[Outlook Units])

      ];