String functions index,replace,keepchar

[Anonymous]

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

[sunny_talwar · Accepted solution]

May be one of the two?

PurgeChar(DBNames, '_') as Field2,

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

[Anonymous]

Thank you ! Sunny 🙂

[Anonymous]

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

We need tips on how to code like you 🙂

[sunny_talwar]

Your very welcome

[sunny_talwar]

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