topic search string and create a new field in QlikView https://community.qlik.com/t5/QlikView/search-string-and-create-a-new-field/m-p/335182#M123592 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a string like 'ABC CDE EFG HIJ' </P><P>From this i need to take first letter of each substring e.g., '<STRONG>A</STRONG>BC <STRONG>C</STRONG>DE <STRONG>E</STRONG>FG <STRONG>H</STRONG>IJ'-ACEH </P><P>I tried to identify space then to fetch the particular string but it didn't work and</P><P> also i used subfield like left(subfield('<STRONG>A</STRONG>BC <STRONG>C</STRONG>DE <STRONG>E</STRONG>FG <STRONG>H</STRONG>IJ',' '),1) i got first letter but when concat its not giving correct result</P><P>Any idea...</P><P></P><P>Regards</P><P>Sivaraj</P></BODY></HTML> Thu, 05 Jul 2012 06:01:39 GMT sivarajs 2012-07-05T06:01:39Z search string and create a new field https://community.qlik.com/t5/QlikView/search-string-and-create-a-new-field/m-p/335182#M123592 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a string like 'ABC CDE EFG HIJ' </P><P>From this i need to take first letter of each substring e.g., '<STRONG>A</STRONG>BC <STRONG>C</STRONG>DE <STRONG>E</STRONG>FG <STRONG>H</STRONG>IJ'-ACEH </P><P>I tried to identify space then to fetch the particular string but it didn't work and</P><P> also i used subfield like left(subfield('<STRONG>A</STRONG>BC <STRONG>C</STRONG>DE <STRONG>E</STRONG>FG <STRONG>H</STRONG>IJ',' '),1) i got first letter but when concat its not giving correct result</P><P>Any idea...</P><P></P><P>Regards</P><P>Sivaraj</P></BODY></HTML> Thu, 05 Jul 2012 06:01:39 GMT https://community.qlik.com/t5/QlikView/search-string-and-create-a-new-field/m-p/335182#M123592 sivarajs 2012-07-05T06:01:39Z Re: search string and create a new field https://community.qlik.com/t5/QlikView/search-string-and-create-a-new-field/m-p/335183#M123593 <HTML><HEAD></HEAD><BODY><P>Hi Sivaraj,</P><P></P><P>This seems to work:</P><P></P><P>Load</P><P>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;concat(Field) as Result;</P><P>Load</P><P> left(subfield('ABC CDE EFG HIJ',' '),1) as Field</P><P>AutoGenerate 1;</P></BODY></HTML> Thu, 05 Jul 2012 06:39:17 GMT https://community.qlik.com/t5/QlikView/search-string-and-create-a-new-field/m-p/335183#M123593 Anonymous 2012-07-05T06:39:17Z Re: search string and create a new field https://community.qlik.com/t5/QlikView/search-string-and-create-a-new-field/m-p/335184#M123594 <HTML><HEAD></HEAD><BODY><P>I tried but its not working</P></BODY></HTML> Thu, 05 Jul 2012 07:00:14 GMT https://community.qlik.com/t5/QlikView/search-string-and-create-a-new-field/m-p/335184#M123594 sivarajs 2012-07-05T07:00:14Z Re: search string and create a new field https://community.qlik.com/t5/QlikView/search-string-and-create-a-new-field/m-p/335185#M123595 <HTML><HEAD></HEAD><BODY><P>It gives me a string ACEH, isn't this what you're looking for?</P></BODY></HTML> Thu, 05 Jul 2012 07:32:12 GMT https://community.qlik.com/t5/QlikView/search-string-and-create-a-new-field/m-p/335185#M123595 Anonymous 2012-07-05T07:32:12Z Re: search string and create a new field https://community.qlik.com/t5/QlikView/search-string-and-create-a-new-field/m-p/335186#M123596 <HTML><HEAD></HEAD><BODY><P>This is what i want, but is not giving for me</P><P>Can you explin the way you have tried?</P></BODY></HTML> Thu, 05 Jul 2012 08:49:25 GMT https://community.qlik.com/t5/QlikView/search-string-and-create-a-new-field/m-p/335186#M123596 sivarajs 2012-07-05T08:49:25Z