Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Subfield function

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...

4 Replies
jagan
Partner - Champion III
Partner - Champion III

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.

Not applicable
Author

Hi Rahul,

Try this,

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

MayilVahanan

Hi

Try like this

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

If its always comes in that place,

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Gabriel
Partner - Specialist III
Partner - Specialist III

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