topic How to replace an specific character under a column in App Development https://community.qlik.com/t5/App-Development/How-to-replace-an-specific-character-under-a-column/m-p/1095845#M18396 <HTML><HEAD></HEAD><BODY><P>Hi guys.</P><P>I have a question on what must be an easy task... I have to replace an specific character under a column.</P><P></P><P>This is what I'm loading in Sense.</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Name</TH></TR><TR><TD style="padding: 2px;">John,Green</TD></TR><TR><TD style="padding: 2px;">Mike,Red</TD></TR><TR><TD style="padding: 2px;">Stephanie,Roberts</TD></TR><TR><TD style="padding: 2px;">Patrick Isaac,Ortner</TD></TR><TR><TD style="padding: 2px;"></TD></TR></TBODY></TABLE><P></P><P>I have to replace the "," by " " (one space)</P><P>How do I do it? Where do I put in the load script?</P><P></P><P>Thank you in advance.</P><P>Regards.</P></BODY></HTML> Fri, 29 Jan 2016 00:36:51 GMT patriciousa 2016-01-29T00:36:51Z How to replace an specific character under a column https://community.qlik.com/t5/App-Development/How-to-replace-an-specific-character-under-a-column/m-p/1095845#M18396 <HTML><HEAD></HEAD><BODY><P>Hi guys.</P><P>I have a question on what must be an easy task... I have to replace an specific character under a column.</P><P></P><P>This is what I'm loading in Sense.</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Name</TH></TR><TR><TD style="padding: 2px;">John,Green</TD></TR><TR><TD style="padding: 2px;">Mike,Red</TD></TR><TR><TD style="padding: 2px;">Stephanie,Roberts</TD></TR><TR><TD style="padding: 2px;">Patrick Isaac,Ortner</TD></TR><TR><TD style="padding: 2px;"></TD></TR></TBODY></TABLE><P></P><P>I have to replace the "," by " " (one space)</P><P>How do I do it? Where do I put in the load script?</P><P></P><P>Thank you in advance.</P><P>Regards.</P></BODY></HTML> Fri, 29 Jan 2016 00:36:51 GMT https://community.qlik.com/t5/App-Development/How-to-replace-an-specific-character-under-a-column/m-p/1095845#M18396 patriciousa 2016-01-29T00:36:51Z Re: How to replace an specific character under a column https://community.qlik.com/t5/App-Development/How-to-replace-an-specific-character-under-a-column/m-p/1095846#M18397 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>Use this in your script ...</P><P></P><P><SPAN class="statement" style="font-weight: bold; color: #444444; font-family: 'Lucida Console', Monaco, monospace; font-size: 13px;">Replace(</SPAN><SPAN style="color: #444444; font-family: 'Lucida Console', Monaco, monospace; font-size: 13px; background-color: #f4f4f4;">text, from_str, to_str</SPAN><SPAN class="statement" style="font-weight: bold; color: #444444; font-family: 'Lucida Console', Monaco, monospace; font-size: 13px;">)</SPAN></P><P><SPAN class="statement" style="font-weight: bold; color: #444444; font-family: 'Lucida Console', Monaco, monospace; font-size: 13px;"><BR /></SPAN></P><P><SPAN class="statement" style="font-weight: bold; color: #444444; font-family: 'Lucida Console', Monaco, monospace; font-size: 13px;"><BR /></SPAN></P></BODY></HTML> Fri, 29 Jan 2016 04:22:17 GMT https://community.qlik.com/t5/App-Development/How-to-replace-an-specific-character-under-a-column/m-p/1095846#M18397 paul_scotchford 2016-01-29T04:22:17Z Re: How to replace an specific character under a column https://community.qlik.com/t5/App-Development/How-to-replace-an-specific-character-under-a-column/m-p/1095847#M18398 <HTML><HEAD></HEAD><BODY><P>Thank you.</P><P>Regards.</P></BODY></HTML> Fri, 29 Jan 2016 13:32:10 GMT https://community.qlik.com/t5/App-Development/How-to-replace-an-specific-character-under-a-column/m-p/1095847#M18398 patriciousa 2016-01-29T13:32:10Z