Qlik sense

[Prasad12]

Hi Everyone,

I am having a field named int_charge having different length of values. Here i need only the values as output excluding      -BDS ,-BDS1,-BDS2....

For eg: If we have the value as TDV3ST-050-BDS3 the output should be TDV3ST-050. Please refer to the excel attached.

[brunobertels · Accepted solution]

hi 

try this 

left('TDV3ST-050-BDS3',index('TDV3ST-050-BDS3','-',2)-1)

[Prasad12]

Thanks, Bruno for you quick reply. It worked

[SankarReddyK]

@Prasad12 , please close the thread by Accept as Solution. Thank you.