topic Re. :string formating in QlikView https://community.qlik.com/t5/QlikView/string-formating/m-p/217808#M70982 <HTML><HEAD></HEAD><BODY><P>Please Sonu, we don't hear very well your problem</P><P>Can you explain it clearly?</P><P>thanks</P></BODY></HTML> Fri, 15 Apr 2011 11:52:33 GMT 2011-04-15T11:52:33Z string formating https://community.qlik.com/t5/QlikView/string-formating/m-p/217807#M70981 <HTML><HEAD></HEAD><BODY><P>I have a string that format is</P><P></P><P></P><TABLE border="0" cellspacing="0" cols="2" frame="void" rules="none"><COLGROUP><COL width="86" /><COL width="368" /></COLGROUP><TBODY><TR><TD align="right" height="18" sdnum="1033;" sdval="1" width="86">1</TD><TD align="left" width="368">A&lt;<A href="mailto:a@tcs.com">a@tcs.com</A>&gt;,d@yahoo.com,B&lt;b@nokia.com&gt;</TD></TR><TR><TD align="right" height="18" sdnum="1033;" sdval="2">2</TD><TD align="left">C&lt;<A href="mailto:c@rediffmail">c@rediffmail</A>.com&gt;,<A href="mailto:N@rediffmail.com">N@rediffmail.com</A></TD></TR><TR><TD align="right" height="18" sdnum="1033;" sdval="3">3</TD><TD align="left"><P>M&lt;<A href="mailto:m@hotmail.com">m@hotmail.com</A>&gt;,S&lt;<A href="mailto:s@synte.com">s@synte.com</A>&gt;</P><P></P></TD></TR></TBODY></TABLE><BR /><BR /> <P></P><P></P><P>but i want output that manner</P><P></P><P></P><TABLE border="0" cellspacing="0" cols="2" frame="void" rules="none"><COLGROUP><COL width="86" /><COL width="368" /></COLGROUP><TBODY><TR><TD align="right" height="18" sdnum="1033;" sdval="1" width="86">1</TD><TD align="left" width="368">@tcs.com</TD></TR><TR><TD align="right" height="18" sdnum="1033;" sdval="1">1</TD><TD align="left">@yahho.com</TD></TR><TR><TD align="right" height="18" sdnum="1033;" sdval="1">1</TD><TD align="left">@nokia.com</TD></TR><TR><TD align="right" height="18" sdnum="1033;" sdval="2">2</TD><TD align="left">@rediffmail.com</TD></TR><TR><TD align="right" height="18" sdnum="1033;" sdval="2">2</TD><TD align="left">@rediffmail.com</TD></TR><TR><TD align="right" height="18" sdnum="1033;" sdval="3">3</TD><TD align="left">@hotmail.com</TD></TR><TR><TD align="right" height="18" sdnum="1033;" sdval="3">3</TD><TD align="left"><P>@syntel.com</P><P></P></TD></TR></TBODY></TABLE><BR /><BR /> <P></P><P>Please help me.</P><P>Regards</P><P>sonu</P></BODY></HTML> Fri, 15 Apr 2011 11:37:51 GMT https://community.qlik.com/t5/QlikView/string-formating/m-p/217807#M70981 2011-04-15T11:37:51Z Re. :string formating https://community.qlik.com/t5/QlikView/string-formating/m-p/217808#M70982 <HTML><HEAD></HEAD><BODY><P>Please Sonu, we don't hear very well your problem</P><P>Can you explain it clearly?</P><P>thanks</P></BODY></HTML> Fri, 15 Apr 2011 11:52:33 GMT https://community.qlik.com/t5/QlikView/string-formating/m-p/217808#M70982 2011-04-15T11:52:33Z