I am trying to clean a field up, during a script transfer but not having alot of sucess with it.
In one field and in table (a) I have H-4870
I have a script that copies it to another field in table (b)
During the transfer I would like to end up with H4870 dropping the dash between the H and the Number
I am not sure of the best why to go about this, I would like for these fields to be a number and not text for internal purposes.
Any help will be met with great appreciation