I assume that your Serial-Number is of variable length!?
One solution you might want to try Is:
- Get the Length of the serialnumber with the Length-Command (This will result to 10 in your example)
- Get the position of the hyphen with the position-command (this will result to 7 in your example)
- Extract the value to the right of the hyphen with: Character right("Serialnumber",Length minus Postion).Length minus postion will result to 3. Three Characters to the right="818"
- This method shoutd work regardless how many Characters there are before and after the hyphen.
PS: I do have only the German enviroment and I hope iI did translate the Commands correctly.
If you want to place an automatic calculation on the field the whole calculation should look as follows:
ZeichenRechts ( "WMX720-818" ; Länge ( "WMX720-818" ) -Position ( "WMX720-818" ; "-" ; 1 ; 1 ))
Länge = Length?
Position = Position?
GetValue ( Substitute ( SerialNumberFieldHere ; "-" ; ¶ ) ; 2 )