topic Re: Subfield function in QlikView

Subfield function

Mon, 15 Sep 2014 07:49:22 GMT

Dear All,

I have a field format like \\becpsn.com\power\projects\j3-cpp\ndh\ in an column Name..

And i have to take Bold letter in that column using subfield function .

plz help...

Re: Subfield function

jagan — Mon, 15 Sep 2014 07:56:03 GMT

Hi Rahul,

It is not possible to get bold letter, while reading in Qlikview it is not possible to identify this. If you have fixed position then you give in SubField().

Hope this helps you.

Regards,

jagan.

Re: Subfield function

Mon, 15 Sep 2014 07:56:10 GMT

Hi Rahul,

Try this,

=subfield('\\becpsn.com\power\projects\j3-cpp\ndh\ in an column Name..','\',5)

Re: Subfield function

MayilVahanan — Mon, 15 Sep 2014 07:58:30 GMT

Try like this

Subfield('\\becpsn.com\power\projects\j3-cpp\ndh\','\',5)

If its always comes in that place,

Re: Subfield function

Gabriel — Mon, 15 Sep 2014 08:25:49 GMT

Hi Rahul,

You can extract the part you want with this code

=SubField('\\becpsn.com\power\projects\j3-cpp\ndh\','\',5)

However, is this a one off thing?

Best Regards,

Gabriel