Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
balrajprabhu
Contributor II

String functions index,replace,keepchar

I have a field which has values like

Management_Desc
Part_Description
IMaster_Spare_Parts_Class_Cd
Spare_Parts_Class_Desc

I want to get rid of the underscore,I'm attaching a sample file

1 Solution

Accepted Solutions

Re: String functions index,replace,keepchar

May be one of the two?

PurgeChar(DBNames, '_') as Field2,

  Replace(DBNames, '_', ' ') as Field3;

5 Replies

Re: String functions index,replace,keepchar

May be one of the two?

PurgeChar(DBNames, '_') as Field2,

  Replace(DBNames, '_', ' ') as Field3;

balrajprabhu
Contributor II

Re: String functions index,replace,keepchar

Thank you ! Sunny 🙂

balrajprabhu
Contributor II

Re: String functions index,replace,keepchar

Sunny ,Lot of us are waiting to read your Blog on Qlikview and Qliksense

We need tips on how to code like you 🙂

Re: String functions index,replace,keepchar

Your very welcome

Re: String functions index,replace,keepchar

I am still learning here, I feel I still have few years before I can come up with a blog. But I will keep everyone posted as soon as I create a Blog