<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>
Dear list, <br>
has anyone experience in how to combine two fields with help of the field calculator?<br>
I have a table with two fields, e.g. [NAME] and [NUMBER].<br>
I inserted a new field called [OUTPUT], where I want to combine all values from [NAME] and [NUMBER].<br>
<br>
<table border="1" cellpadding="2" cellspacing="2" height="58" width="876">
<tbody>
<tr>
<td valign="top">ID<br>
</td>
<td valign="top">NAME<br>
</td>
<td valign="top">NUMBER<br>
</td>
<td valign="top">OUTPUT<br>
</td>
</tr>
<tr>
<td valign="top">1<br>
</td>
<td valign="top">TEST<br>
</td>
<td valign="top">10000<br>
</td>
<td valign="top">TEST: 10000 No.<br>
</td>
</tr>
</tbody>
</table>
<br>
Afterwards I want to create symbology for [OUTPUT] and want to display it in the map layout.<br>
Now my question: Is there a way to calculate this [OUTPUT] including two
fields and extra syntax, like "commas", "double points",.. with help of the field calculator, like e.g. this: <br>
[TEST]":" [NUMBER]" No."<br>Maybe the advanced tab could be helpful where I can include python-scripts?<br><br>
Thanks in advance!<br>
Ruth<br>
<br><br>Ruth Schönbuchner<br><b>CSGIS</b><br>Email:ruth.schoenbuchner@csgis.de<br>Web: h<b>ttp://www.csgis.de</b> </div></body>
</html>