topic Re: How to get only part of data from column values? in QlikView https://community.qlik.com/t5/QlikView/How-to-get-only-part-of-data-from-column-values/m-p/701184#M1054778 <HTML><HEAD></HEAD><BODY><P>Thanks. for some of the fields it is showing address values as below.</P><P></P><P>Input</P><P></P><P>Apartment 45, 45 Bell Barn Road, Birmingham, GBR</P><P></P><P>Output</P><P></P><P>45 Bell Barn Road</P><P></P><P>but actual output should be</P><P></P><P>Birmingham</P><P></P><P>How can I set this please suggest</P></BODY></HTML> Mon, 27 Oct 2014 11:23:40 GMT 2014-10-27T11:23:40Z How to get only part of data from column values? https://community.qlik.com/t5/QlikView/How-to-get-only-part-of-data-from-column-values/m-p/701178#M1054772 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have values in one column as below</P><P></P><P>43 side Drive, Leeds, GBR<BR />67 Bradfield Way, Chard, GBR<BR />345 Broadweird Road, Cwmbran, GBR<BR />Verona Barn Chester Road, Barbridge Cheshire, GBR<BR />21 Hulton Close, Southampton, GBR</P><P><BR />How can I get values only </P><P></P><P>Leeds<BR />Chard<BR />Cwmbran<BR />Cheshire<BR />Southampton</P><P></P><P>Please can anyone suggest me soon please</P><P></P><P>Thanks.</P></BODY></HTML> Mon, 27 Oct 2014 10:51:42 GMT https://community.qlik.com/t5/QlikView/How-to-get-only-part-of-data-from-column-values/m-p/701178#M1054772 2014-10-27T10:51:42Z Re: How to get only part of data from column values? https://community.qlik.com/t5/QlikView/How-to-get-only-part-of-data-from-column-values/m-p/701179#M1054773 <HTML><HEAD></HEAD><BODY><P>If your field name is for example "Address" then write:</P><P></P><P>Subfield(Address,',',2)</P><P></P><P>let me know</P></BODY></HTML> Mon, 27 Oct 2014 10:55:52 GMT https://community.qlik.com/t5/QlikView/How-to-get-only-part-of-data-from-column-values/m-p/701179#M1054773 alexandros17 2014-10-27T10:55:52Z Re: How to get only part of data from column values? https://community.qlik.com/t5/QlikView/How-to-get-only-part-of-data-from-column-values/m-p/701180#M1054774 <HTML><HEAD></HEAD><BODY><P>subfield(MyField, ',',2) will return the part between the first and second comma of MyField.</P></BODY></HTML> Mon, 27 Oct 2014 10:56:57 GMT https://community.qlik.com/t5/QlikView/How-to-get-only-part-of-data-from-column-values/m-p/701180#M1054774 Gysbert_Wassenaar 2014-10-27T10:56:57Z Re: How to get only part of data from column values? https://community.qlik.com/t5/QlikView/How-to-get-only-part-of-data-from-column-values/m-p/701181#M1054775 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Subfield(Fieldname,',',2) as Newfield</P><P>Then you will get the data wat ever you want.</P></BODY></HTML> Mon, 27 Oct 2014 11:03:37 GMT https://community.qlik.com/t5/QlikView/How-to-get-only-part-of-data-from-column-values/m-p/701181#M1054775 2014-10-27T11:03:37Z Re: How to get only part of data from column values? https://community.qlik.com/t5/QlikView/How-to-get-only-part-of-data-from-column-values/m-p/701182#M1054776 <HTML><HEAD></HEAD><BODY><P>Thanks.</P><P></P><P>I can see the left space in the values at the starting of word. Please can suggest me how can I set this?</P></BODY></HTML> Mon, 27 Oct 2014 11:12:45 GMT https://community.qlik.com/t5/QlikView/How-to-get-only-part-of-data-from-column-values/m-p/701182#M1054776 2014-10-27T11:12:45Z Re: How to get only part of data from column values? https://community.qlik.com/t5/QlikView/How-to-get-only-part-of-data-from-column-values/m-p/701183#M1054777 <HTML><HEAD></HEAD><BODY><P>trim(Subfield('21 Hulton Close, Southampton, GBR',',',2))</P><P></P><P>Thanks</P><P></P><P>Mark</P><P></P><P>www.techstuffy.com</P></BODY></HTML> Mon, 27 Oct 2014 11:15:39 GMT https://community.qlik.com/t5/QlikView/How-to-get-only-part-of-data-from-column-values/m-p/701183#M1054777 markodonovan 2014-10-27T11:15:39Z Re: How to get only part of data from column values? https://community.qlik.com/t5/QlikView/How-to-get-only-part-of-data-from-column-values/m-p/701184#M1054778 <HTML><HEAD></HEAD><BODY><P>Thanks. for some of the fields it is showing address values as below.</P><P></P><P>Input</P><P></P><P>Apartment 45, 45 Bell Barn Road, Birmingham, GBR</P><P></P><P>Output</P><P></P><P>45 Bell Barn Road</P><P></P><P>but actual output should be</P><P></P><P>Birmingham</P><P></P><P>How can I set this please suggest</P></BODY></HTML> Mon, 27 Oct 2014 11:23:40 GMT https://community.qlik.com/t5/QlikView/How-to-get-only-part-of-data-from-column-values/m-p/701184#M1054778 2014-10-27T11:23:40Z