topic Re: Spliting data with multiple delimiters in QlikView https://community.qlik.com/t5/QlikView/Spliting-data-with-multiple-delimiters/m-p/1355379#M823459 <HTML><HEAD></HEAD><BODY><P>maybe</P><P></P><P>SubField(Replace([<STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Movie Genre</STRONG>],',','|'),'|') as <SPAN style="font-size: 13.3333px;">[</SPAN><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Movie Genre</STRONG><SPAN style="font-size: 13.3333px;">]</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">?</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">hope this helps</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">regards</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Marco</SPAN></P></BODY></HTML> Sun, 23 Jul 2017 01:04:58 GMT MarcoWedel 2017-07-23T01:04:58Z Spliting data with multiple delimiters https://community.qlik.com/t5/QlikView/Spliting-data-with-multiple-delimiters/m-p/1355378#M823458 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have some data which have multiple delimiters.</P><P></P><P><STRONG>E.g for Movie Genre</STRONG></P><P>Comedy | Romance</P><P>Comedy , Romance</P><P>Action | Fantasy</P><P>Action , Fantasy</P><P></P><P>I would like to split them into single genre. How can i use subfield() to include both the " | " and " , " delimiters?</P><P></P><P>Thanks!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Spliting-data-with-multiple-delimiters/m-p/1355378#M823458 2020-11-25T16:16:04Z Re: Spliting data with multiple delimiters https://community.qlik.com/t5/QlikView/Spliting-data-with-multiple-delimiters/m-p/1355379#M823459 <HTML><HEAD></HEAD><BODY><P>maybe</P><P></P><P>SubField(Replace([<STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Movie Genre</STRONG>],',','|'),'|') as <SPAN style="font-size: 13.3333px;">[</SPAN><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Movie Genre</STRONG><SPAN style="font-size: 13.3333px;">]</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">?</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">hope this helps</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">regards</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Marco</SPAN></P></BODY></HTML> Sun, 23 Jul 2017 01:04:58 GMT https://community.qlik.com/t5/QlikView/Spliting-data-with-multiple-delimiters/m-p/1355379#M823459 MarcoWedel 2017-07-23T01:04:58Z