Combining mid & index

[#1]

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

[sunny_talwar]

May be this:

If(Len(Trim(mid(Fund_Name, 1, index(Fund_Name, ' ')-1))) > 0, mid(Fund_Name, 1, index(Fund_Name, ' ')-1))