topic SUBFILED WITH SPACE in QlikView https://community.qlik.com/t5/QlikView/SUBFILED-WITH-SPACE/m-p/1372580#M616297 <HTML><HEAD></HEAD><BODY><P>Bonjour,</P><P>Je veux diffusionner un champs sur deux.&nbsp;&nbsp; Ce champs contient un nom et un prenom séparés par des espaces. </P><P>Comment pourrai je les séparer.</P><P>Voila mon essai: </P><P>subfield(LIBELLE,'',1)&nbsp; as MENOM , </P><P>subfield(LIBELLE,'',2)&nbsp; as MEPRENOM , </P><P></P><P>Merci </P></BODY></HTML> Thu, 15 Jun 2017 09:30:32 GMT chadliagabsi 2017-06-15T09:30:32Z SUBFILED WITH SPACE https://community.qlik.com/t5/QlikView/SUBFILED-WITH-SPACE/m-p/1372580#M616297 <HTML><HEAD></HEAD><BODY><P>Bonjour,</P><P>Je veux diffusionner un champs sur deux.&nbsp;&nbsp; Ce champs contient un nom et un prenom séparés par des espaces. </P><P>Comment pourrai je les séparer.</P><P>Voila mon essai: </P><P>subfield(LIBELLE,'',1)&nbsp; as MENOM , </P><P>subfield(LIBELLE,'',2)&nbsp; as MEPRENOM , </P><P></P><P>Merci </P></BODY></HTML> Thu, 15 Jun 2017 09:30:32 GMT https://community.qlik.com/t5/QlikView/SUBFILED-WITH-SPACE/m-p/1372580#M616297 chadliagabsi 2017-06-15T09:30:32Z Re: SUBFILED WITH SPACE https://community.qlik.com/t5/QlikView/SUBFILED-WITH-SPACE/m-p/1372581#M616298 <HTML><HEAD></HEAD><BODY><P>utilisez ceci</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">subfield(LIBELLE,' ',1)&nbsp; as MENOM ,</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">subfield(LIBELLE,' ',2)&nbsp; as MEPRENOM , // <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">subfield(LIBELLE,' ',-1)&nbsp; as MEPRENOM ,</SPAN></P></BODY></HTML> Thu, 15 Jun 2017 09:33:37 GMT https://community.qlik.com/t5/QlikView/SUBFILED-WITH-SPACE/m-p/1372581#M616298 Anil_Babu_Samineni 2017-06-15T09:33:37Z Re: SUBFILED WITH SPACE https://community.qlik.com/t5/QlikView/SUBFILED-WITH-SPACE/m-p/1372582#M616299 <HTML><HEAD></HEAD><BODY><P>Merci Anil il me manque seulement l'espace.</P></BODY></HTML> Thu, 15 Jun 2017 09:38:04 GMT https://community.qlik.com/t5/QlikView/SUBFILED-WITH-SPACE/m-p/1372582#M616299 chadliagabsi 2017-06-15T09:38:04Z