topic Re: How to split Address? in QlikView https://community.qlik.com/t5/QlikView/How-to-split-Address/m-p/1764554#M1149626 <P>Thank you for making this. Very usefull for me</P> Thu, 26 Nov 2020 04:45:00 GMT Johan_Kassing 2020-11-26T04:45:00Z How to split Address? https://community.qlik.com/t5/QlikView/How-to-split-Address/m-p/398135#M1149624 <HTML><HEAD></HEAD><BODY><P>I have these senerio's where I have to split my Address into Address,state,zip,phone number etc.</P><P>How to use string function or which string function or any other function.Please explain.</P><P>For example:</P><P>1) </P><P>1 Queen St. @ Yonge</P><P>1 Queen Street East</P><P>Toronto, Ontario M5C 2W5</P><P>(416) 363-8555 </P><P></P><P>2)</P><P>Coastland Center E-7</P><P>1900 Tamiami Trail Noth</P><P>Naples, Florida 34102</P><P>239-261-4398</P><P></P><P>3)</P><P>891 Dunsmuir</P><P>885 Dunsmuir Street</P><P>Vancouver, British Columbia V6C 3K4</P><P>604/688-9098</P></BODY></HTML> Thu, 23 May 2013 02:33:19 GMT https://community.qlik.com/t5/QlikView/How-to-split-Address/m-p/398135#M1149624 2013-05-23T02:33:19Z Re: How to split Address? https://community.qlik.com/t5/QlikView/How-to-split-Address/m-p/398136#M1149625 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>One possible way but not reliable &amp; is complete hardcoding.</P><P></P><P>Regards,</P></BODY></HTML> Thu, 23 May 2013 10:59:58 GMT https://community.qlik.com/t5/QlikView/How-to-split-Address/m-p/398136#M1149625 gaurav2017 2013-05-23T10:59:58Z Re: How to split Address? https://community.qlik.com/t5/QlikView/How-to-split-Address/m-p/1764554#M1149626 <P>Thank you for making this. Very usefull for me</P> Thu, 26 Nov 2020 04:45:00 GMT https://community.qlik.com/t5/QlikView/How-to-split-Address/m-p/1764554#M1149626 Johan_Kassing 2020-11-26T04:45:00Z