https://community.jmp.com/t5/Discussions/How-to-merge-Text-Character/m-p/258610#M50797 <P>:Char.A || "_" || :Char.B</P> Fri, 17 Apr 2020 07:33:06 GMT txnelson 2020-04-17T07:33:06Z https://community.jmp.com/t5/Discussions/How-to-merge-Text-Character/m-p/258602#M50795 <P>Dear Sir</P><P>&nbsp;</P><P>I try find the related discussion before, but it seems not easy.</P><P>I would like ask how to&nbsp; merge Char.A + Char.B in new column, thank you.</P><DIV class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV><TABLE><TBODY><TR><TD>Char.A</TD><TD>Char.B</TD><TD><FONT color="#000000">Merge</FONT></TD></TR><TR><TD>A</TD><TD>01</TD><TD><FONT color="#000000">A.01</FONT></TD></TR><TR><TD>B</TD><TD>02</TD><TD><FONT color="#000000">B.02</FONT></TD></TR><TR><TD>C</TD><TD>03</TD><TD><FONT color="#000000">C.03</FONT></TD></TR><TR><TD>D</TD><TD>04</TD><TD><FONT color="#000000">D.04</FONT></TD></TR><TR><TD>E</TD><TD>05</TD><TD><FONT color="#000000">E.05</FONT></TD></TR><TR><TD>F</TD><TD>06</TD><TD><FONT color="#000000">F.06</FONT></TD></TR><TR><TD>G</TD><TD>07</TD><TD><FONT color="#000000">G.07</FONT></TD></TR></TBODY></TABLE><DIV class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV><P>&nbsp;</P><DIV class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV><P>&nbsp;</P><DIV class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV><P>&nbsp;</P><P>&nbsp;</P> Fri, 17 Apr 2020 06:38:25 GMT https://community.jmp.com/t5/Discussions/How-to-merge-Text-Character/m-p/258602#M50795 StevenChan 2020-04-17T06:38:25Z https://community.jmp.com/t5/Discussions/How-to-merge-Text-Character/m-p/258607#M50796 <P>Dear Sis</P><P>Let me describe again,</P><P>Merge1 is doable form formula (character --&gt; concat)</P><P>Merge2&nbsp; I wish to add new character (not in data table), like "_"&nbsp; dash. how to reach this..</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="StevenChan_0-1587106307047.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/23160iB8B54711B004A4F0/image-size/medium?v=v2&amp;px=400" role="button" title="StevenChan_0-1587106307047.png" alt="StevenChan_0-1587106307047.png" /></span></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="StevenChan_1-1587106333468.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/23161i83C2D22E9232F68E/image-size/medium?v=v2&amp;px=400" role="button" title="StevenChan_1-1587106333468.png" alt="StevenChan_1-1587106333468.png" /></span></P><P>&nbsp;</P><P>&nbsp;</P> Fri, 17 Apr 2020 06:56:42 GMT https://community.jmp.com/t5/Discussions/How-to-merge-Text-Character/m-p/258607#M50796 StevenChan 2020-04-17T06:56:42Z https://community.jmp.com/t5/Discussions/How-to-merge-Text-Character/m-p/258610#M50797 <P>:Char.A || "_" || :Char.B</P> Fri, 17 Apr 2020 07:33:06 GMT https://community.jmp.com/t5/Discussions/How-to-merge-Text-Character/m-p/258610#M50797 txnelson 2020-04-17T07:33:06Z https://community.jmp.com/t5/Discussions/How-to-merge-Text-Character/m-p/258673#M50810 Thanks for quick answer Fri, 17 Apr 2020 14:49:55 GMT https://community.jmp.com/t5/Discussions/How-to-merge-Text-Character/m-p/258673#M50810 StevenChan 2020-04-17T14:49:55Z