topic Re: want to replace particular delimiter in QlikView https://community.qlik.com/t5/QlikView/want-to-replace-particular-delimiter/m-p/132821#M752097 <HTML><HEAD></HEAD><BODY><P>Yes it worked..thanks!</P></BODY></HTML> Fri, 26 Oct 2018 06:47:06 GMT Anonymous 2018-10-26T06:47:06Z want to replace particular delimiter https://community.qlik.com/t5/QlikView/want-to-replace-particular-delimiter/m-p/132816#M752092 <HTML><HEAD></HEAD><BODY><P>I want to replace particular delimiter '#' with other i.e '~' from the field value. How can i do that ?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/want-to-replace-particular-delimiter/m-p/132816#M752092 Anonymous 2020-11-25T16:16:04Z Re: want to replace particular delimiter https://community.qlik.com/t5/QlikView/want-to-replace-particular-delimiter/m-p/132817#M752093 <HTML><HEAD></HEAD><BODY><P>may be try like,</P><P></P><P>Replace(Fieldname, '#', '~') AS NewReplacedField</P></BODY></HTML> Wed, 24 Oct 2018 16:49:42 GMT https://community.qlik.com/t5/QlikView/want-to-replace-particular-delimiter/m-p/132817#M752093 vishsaggi 2018-10-24T16:49:42Z Re: want to replace particular delimiter https://community.qlik.com/t5/QlikView/want-to-replace-particular-delimiter/m-p/132818#M752094 <HTML><HEAD></HEAD><BODY><P>Can I replace all the occurrences at once with this function? or do I need to use replace as many times the delimiter occurs?</P><P>PFB the kind of data I have</P><P></P><P>EB1D7C5EBA6B4F91B146ACFE5621C98E###5EBA6B4F91B146ACFE5###Initiate_Construction###In Progress######12123123333###EB1D7C5EBA6BOrder1213323###0###EB1D7C5EBA6B4F91B146ACFE5621C98X###EB1D7C5EBA6B4F91B146ACFE5621C98Y###iFrameworkAgreement1012###</P></BODY></HTML> Thu, 25 Oct 2018 06:14:56 GMT https://community.qlik.com/t5/QlikView/want-to-replace-particular-delimiter/m-p/132818#M752094 Anonymous 2018-10-25T06:14:56Z Re: want to replace particular delimiter https://community.qlik.com/t5/QlikView/want-to-replace-particular-delimiter/m-p/132819#M752095 <HTML><HEAD></HEAD><BODY><P>Replace('EB1D7C5EBA6B4F91B146ACFE5621C98E###5EBA6B4F91B146ACFE5###Initiate_Construction###In Progress######12123123333###EB1D7C5EBA6BOrder1213323###0###EB1D7C5EBA6B4F91B146ACFE5621C98X###EB1D7C5EBA6B4F91B146ACFE5621C98Y###iFrameworkAgreement1012###','###','~')</P></BODY></HTML> Thu, 25 Oct 2018 16:39:42 GMT https://community.qlik.com/t5/QlikView/want-to-replace-particular-delimiter/m-p/132819#M752095 jerifortune 2018-10-25T16:39:42Z Re: want to replace particular delimiter https://community.qlik.com/t5/QlikView/want-to-replace-particular-delimiter/m-p/132820#M752096 <HTML><HEAD></HEAD><BODY><P>Try</P><P> Replace("XYZ",'-','') as "XYZ",</P></BODY></HTML> Thu, 25 Oct 2018 17:54:51 GMT https://community.qlik.com/t5/QlikView/want-to-replace-particular-delimiter/m-p/132820#M752096 Anonymous 2018-10-25T17:54:51Z Re: want to replace particular delimiter https://community.qlik.com/t5/QlikView/want-to-replace-particular-delimiter/m-p/132821#M752097 <HTML><HEAD></HEAD><BODY><P>Yes it worked..thanks!</P></BODY></HTML> Fri, 26 Oct 2018 06:47:06 GMT https://community.qlik.com/t5/QlikView/want-to-replace-particular-delimiter/m-p/132821#M752097 Anonymous 2018-10-26T06:47:06Z