remove of change a character from string

[gidon500]

Hi guy

I need to remove or change a character   '-'   from  a string ,

In case of change '-' to 'X'

input

Field

Z100-100

Z200-300

output

filedRemove

Z100100

Z200300

FieldChange

Z100X100

Z200X300

any easy way to do it

thanks

gidon

[maxgro · Accepted solution]

replace(field, '-', '')

replace(field, '-', 'X')

[gidon500]

thanks

gidon