topic Re: How to get a word into a text string field in QlikView https://community.qlik.com/t5/QlikView/How-to-get-a-word-into-a-text-string-field/m-p/1165729#M379520 <HTML><HEAD></HEAD><BODY><P>You're welcome</P><P></P><P>glad it helped</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Thu, 09 Jun 2016 23:32:00 GMT MarcoWedel 2016-06-09T23:32:00Z How to get a word into a text string field https://community.qlik.com/t5/QlikView/How-to-get-a-word-into-a-text-string-field/m-p/1165725#M379516 <HTML><HEAD></HEAD><BODY><P>Hello Everybody! Could guide to me in this question please? </P><P></P><P>The case is: </P><P><SPAN lang="en"><SPAN>I have</SPAN> a field with the number and description of the department.<BR /><SPAN>But</SPAN> <SPAN>I require</SPAN> only show the first word of the department without their number.<BR /></SPAN><SPAN lang="en">The issue is when the departmet has 1 word, it solution can't do it, because the delimiter isn't a space or any other.</SPAN></P><P><SPAN lang="en"><SPAN lang="en"><BR /></SPAN></SPAN></P><P><SPAN lang="en"><SPAN lang="en">I tried it with the following function:</SPAN></SPAN></P><P><SPAN lang="en">MID(Departamento,4,Index(Departamento,' ',2)-4) as TestMidIndex</SPAN></P><P><SPAN lang="en"><BR /></SPAN></P><P><SPAN lang="en"><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/127476_pastedImage_7.png" style="max-width: 1200px; max-height: 900px;" /><BR />Also attach an excel and <SPAN>qvd examples</SPAN><SPAN>.</SPAN><BR /></SPAN></P><P><SPAN lang="en"><BR /></SPAN></P><P><SPAN lang="en">I will appreciate your support.<BR />Thanks for advance <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></SPAN></P></BODY></HTML> Thu, 09 Jun 2016 21:13:21 GMT https://community.qlik.com/t5/QlikView/How-to-get-a-word-into-a-text-string-field/m-p/1165725#M379516 2016-06-09T21:13:21Z Re: How to get a word into a text string field https://community.qlik.com/t5/QlikView/How-to-get-a-word-into-a-text-string-field/m-p/1165726#M379517 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Subfield(MID(Departamento,5),' ',1) as TestMidIndex</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">regards</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Marco<BR /></SPAN></P></BODY></HTML> Thu, 09 Jun 2016 21:54:30 GMT https://community.qlik.com/t5/QlikView/How-to-get-a-word-into-a-text-string-field/m-p/1165726#M379517 MarcoWedel 2016-06-09T21:54:30Z Re: How to get a word into a text string field https://community.qlik.com/t5/QlikView/How-to-get-a-word-into-a-text-string-field/m-p/1165727#M379518 <HTML><HEAD></HEAD><BODY><P>or</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Subfield(Departamento,' ',2) as TestMidIndex</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">?<BR /></SPAN></P></BODY></HTML> Thu, 09 Jun 2016 21:55:20 GMT https://community.qlik.com/t5/QlikView/How-to-get-a-word-into-a-text-string-field/m-p/1165727#M379518 MarcoWedel 2016-06-09T21:55:20Z Re: How to get a word into a text string field https://community.qlik.com/t5/QlikView/How-to-get-a-word-into-a-text-string-field/m-p/1165728#M379519 <HTML><HEAD></HEAD><BODY><P>Dear Marco, </P><P>It is fixing good!</P><P>Thanks a lot for your quik answear, i appreciate it.</P><P></P><P>Best Regards! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/grin.png" /></P></BODY></HTML> Thu, 09 Jun 2016 22:33:16 GMT https://community.qlik.com/t5/QlikView/How-to-get-a-word-into-a-text-string-field/m-p/1165728#M379519 2016-06-09T22:33:16Z Re: How to get a word into a text string field https://community.qlik.com/t5/QlikView/How-to-get-a-word-into-a-text-string-field/m-p/1165729#M379520 <HTML><HEAD></HEAD><BODY><P>You're welcome</P><P></P><P>glad it helped</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Thu, 09 Jun 2016 23:32:00 GMT https://community.qlik.com/t5/QlikView/How-to-get-a-word-into-a-text-string-field/m-p/1165729#M379520 MarcoWedel 2016-06-09T23:32:00Z