topic Re: String functions index,replace,keepchar in QlikView https://community.qlik.com/t5/QlikView/String-functions-index-replace-keepchar/m-p/1035160#M939335 <HTML><HEAD></HEAD><BODY><P>Thank you ! Sunny <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P></BODY></HTML> Tue, 02 Feb 2016 21:17:09 GMT Anonymous 2016-02-02T21:17:09Z String functions index,replace,keepchar https://community.qlik.com/t5/QlikView/String-functions-index-replace-keepchar/m-p/1035158#M939333 <HTML><HEAD></HEAD><BODY><P>I have a field which has values like</P><P></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 267px;"><TBODY><TR><TD class="xl63" height="17" width="267"></TD></TR><TR><TD class="xl63" height="17">Management_Desc</TD></TR><TR><TD class="xl63" height="17">Part_Description</TD></TR><TR><TD class="xl63" height="17">IMaster_Spare_Parts_Class_Cd</TD></TR><TR><TD class="xl63" height="17">Spare_Parts_Class_Desc</TD></TR><TR><TD class="xl63" height="17"><P></P></TD></TR></TBODY></TABLE><P>I want to get rid of the underscore,I'm attaching a sample file</P></BODY></HTML> Tue, 02 Feb 2016 21:07:27 GMT https://community.qlik.com/t5/QlikView/String-functions-index-replace-keepchar/m-p/1035158#M939333 Anonymous 2016-02-02T21:07:27Z Re: String functions index,replace,keepchar https://community.qlik.com/t5/QlikView/String-functions-index-replace-keepchar/m-p/1035159#M939334 <HTML><HEAD></HEAD><BODY><P>May be one of the two?</P><P></P><P><STRONG> <SPAN style="color: #ff0000;"> PurgeChar(DBNames, '_') as Field2,</SPAN></STRONG></P><P><SPAN style="color: #ff0000;"><STRONG>&nbsp; Replace(DBNames, '_', ' ') as Field3;</STRONG></SPAN></P></BODY></HTML> Tue, 02 Feb 2016 21:10:47 GMT https://community.qlik.com/t5/QlikView/String-functions-index-replace-keepchar/m-p/1035159#M939334 sunny_talwar 2016-02-02T21:10:47Z Re: String functions index,replace,keepchar https://community.qlik.com/t5/QlikView/String-functions-index-replace-keepchar/m-p/1035160#M939335 <HTML><HEAD></HEAD><BODY><P>Thank you ! Sunny <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P></BODY></HTML> Tue, 02 Feb 2016 21:17:09 GMT https://community.qlik.com/t5/QlikView/String-functions-index-replace-keepchar/m-p/1035160#M939335 Anonymous 2016-02-02T21:17:09Z Re: String functions index,replace,keepchar https://community.qlik.com/t5/QlikView/String-functions-index-replace-keepchar/m-p/1035161#M939336 <HTML><HEAD></HEAD><BODY><P>Sunny ,Lot of us are waiting to read your Blog on Qlikview and Qliksense</P><P></P><P>We need tips on how to code like you <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P></BODY></HTML> Tue, 02 Feb 2016 21:30:20 GMT https://community.qlik.com/t5/QlikView/String-functions-index-replace-keepchar/m-p/1035161#M939336 Anonymous 2016-02-02T21:30:20Z Re: String functions index,replace,keepchar https://community.qlik.com/t5/QlikView/String-functions-index-replace-keepchar/m-p/1035162#M939337 <HTML><HEAD></HEAD><BODY><P>Your very welcome</P></BODY></HTML> Tue, 02 Feb 2016 21:30:28 GMT https://community.qlik.com/t5/QlikView/String-functions-index-replace-keepchar/m-p/1035162#M939337 sunny_talwar 2016-02-02T21:30:28Z Re: String functions index,replace,keepchar https://community.qlik.com/t5/QlikView/String-functions-index-replace-keepchar/m-p/1035163#M939338 <HTML><HEAD></HEAD><BODY><P>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 <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 02 Feb 2016 21:32:21 GMT https://community.qlik.com/t5/QlikView/String-functions-index-replace-keepchar/m-p/1035163#M939338 sunny_talwar 2016-02-02T21:32:21Z