Adding to Expression "-01" to a value

[DennisHolstein]

Dear all, I just want to create a new column. The value of this column should just append the value of an existing column by "-01". For example: the existing value is "150000", I intend to create a new column which is "150000-01". Many thanks for your help in advance. Best regards Dennis

[BenMoss · Accepted solution]

You need to use a formula tool to do this (this allows you to create fields).

And then you can use the statement...

[MyField]+"-01"

This will only work however, if the existing field you want to append to (which I have titled MyField), is already a string, otherwise you may have to use the statement...

TOSTRING([MyField])+"-01"

Or use a select tool prior to the formula to change the datatype.

Ben

[DennisHolstein]

Many thanks for the fast support.