topic Read string untill blank space in QlikView https://community.qlik.com/t5/QlikView/Read-string-untill-blank-space/m-p/154149#M30867 <HTML><HEAD></HEAD><BODY><P>Functions left and right take the specific number of characters that should be included...</P><P>For your needs, function SUBFIELD would work better:</P><P>Part1 = SUBFIELD(Name, ' ', 1)</P><P>Part2 = SUBFIELD(Name, ' ', 2)</P><P>For the purpose of extracting first initial and last name, use a combination of the two:</P><P>left(Name,1) &amp; SUBFIELD(Name, ' ', 2)</P><P>cheers,</P><P></P><P></P></BODY></HTML> Thu, 10 Mar 2011 15:34:26 GMT Oleg_Troyansky 2011-03-10T15:34:26Z Read string untill blank space https://community.qlik.com/t5/QlikView/Read-string-untill-blank-space/m-p/154148#M30866 <HTML><HEAD></HEAD><BODY><P>Greetings!</P><P>Simple question:</P><P>I have a string such as "THIAGO RIBEIRO", and I want to treat it to outcome like "TRIBEIRO"...</P><P>I tried something like <B>LEFT(NAME,1) &amp; RIGHT(NAME,' ')</B>, but unsuccesfuly...</P><P>Can anyone see where I'm going wrong in the RIGHT func?</P><P>Thx again!!!</P></BODY></HTML> Thu, 10 Mar 2011 15:30:39 GMT https://community.qlik.com/t5/QlikView/Read-string-untill-blank-space/m-p/154148#M30866 2011-03-10T15:30:39Z Read string untill blank space https://community.qlik.com/t5/QlikView/Read-string-untill-blank-space/m-p/154149#M30867 <HTML><HEAD></HEAD><BODY><P>Functions left and right take the specific number of characters that should be included...</P><P>For your needs, function SUBFIELD would work better:</P><P>Part1 = SUBFIELD(Name, ' ', 1)</P><P>Part2 = SUBFIELD(Name, ' ', 2)</P><P>For the purpose of extracting first initial and last name, use a combination of the two:</P><P>left(Name,1) &amp; SUBFIELD(Name, ' ', 2)</P><P>cheers,</P><P></P><P></P></BODY></HTML> Thu, 10 Mar 2011 15:34:26 GMT https://community.qlik.com/t5/QlikView/Read-string-untill-blank-space/m-p/154149#M30867 Oleg_Troyansky 2011-03-10T15:34:26Z Read string untill blank space https://community.qlik.com/t5/QlikView/Read-string-untill-blank-space/m-p/154150#M30868 <HTML><HEAD></HEAD><BODY><P>Oleg,</P><P>Owe you another one... Worked perfectly!</P><P>Thank you so much!</P></BODY></HTML> Thu, 10 Mar 2011 16:13:11 GMT https://community.qlik.com/t5/QlikView/Read-string-untill-blank-space/m-p/154150#M30868 2011-03-10T16:13:11Z