1 Reply Latest reply: May 2, 2016 8:31 AM by Sunny Talwar RSS

    QS- Blank Value

    Kshitija Shinde

      Hello everyone,

       

                So my question is i have hightlighted some words in the below code, i want to print the blank spaces count. I have blank spaces in my excel n want to remove their count but not getting their count. Am i using the right way to do so?

       

       

      [Sheet1$]:

      LOAD

      [DOCUMENT NO],

        [DOCUMENT DATE],

        [DOCUMENT TYPE],

        [DOCUMENT STATE],

        [ACTIVITY DATE],

        [FILE FORMAT],

        [CLIENT CODE],

        [CLIENT NAME],

        [CLIENT EMAIL],

        [ALT EMAIL],

        [BCC EMAIL],

        [LOGIN USERNAME],

        [SOURCE FILE],

        [EXCHANGE],

        [IntDmatLogID],

        [ClientType],

          if(BO_Reason='General Bounce'or BO_Reason=' ' or BO_Reason='Soft Bounce - General','Soft Bounce','Hard Bounce') as dd,

        [BO_Reason]

      FROM []

      (biff, embedded labels, table is Sheet1$);

       

      Table2:

      Load*Inline

      [

      ClientType,ClientTypeNew

      1,'ECN'

      2,'Non-ECN'

      ];

       

      Table3:

      Load*Inline

      [

      BO_Reason,Bounce_Category

      'General Bounce','Soft Bounce'

      '    ','Soft Bounce'

      'Hard Bounce','Hard Bounce'

      'Soft Bounce - General','Soft Bounce'

       

       

      Thanks& Regards,

      Kshitija