Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
replace(field, '-', '')
replace(field, '-', 'X')
thanks
gidon