topic Re: truncating data in a given string in QlikView

truncating data in a given string

Wed, 25 Feb 2015 19:19:03 GMT

Hi,

I have a field having data like this 876-1209 (c-BENlhnhg 9.l0./10) and I want truncate the data after bracket begins and my output should be 876-1209

Can you pls let me know which function works, I tried using sub string but couldn't success.

Thanks,

Re: truncating data in a given string

marcus_sommer — Wed, 25 Feb 2015 19:24:11 GMT

Try: subfield(YourField, '(', 1)

- Marcus

Re: truncating data in a given string

eespiritu — Wed, 25 Feb 2015 19:37:31 GMT

Hi,

This is other option: left(YourString,index(YourString,'(')-1)

Regards,

Enrique

Re: truncating data in a given string

Wed, 25 Feb 2015 19:42:51 GMT

Thanks Marcus it is working as expected.

Thanks,