1 Reply Latest reply: Oct 26, 2015 11:48 AM by Sunny Talwar RSS

    Combining mid & index

    Mukundan K

      Hi

      I am extracting data from SQL Server getting Distinct Fund name

       

       

      LOAD Distinct("Fund_Name");
      SQL SELECT "Fund_Name"
      FROM "FI_Dashboard".dbo."VR_Data"
      WHERE "FUND_NAME" NOT IN ('NO_OF_FUNDS')
      order by "Fund_Name";

       

       

      =mid(Fund_Name, 1, index(Fund_Name, ' ')-1)

       

      Using mid & index, I am getting the value from the Fund Name

       

      ie., Axis Short Term Fund --> 'Axis'

       

      But I am getting a blank field on Top (image attached).  How to avoid this blank column.

       

      Mukundan