7 Replies Latest reply on Aug 31, 2012 10:59 AM by Stephen Huston

    Cleaning Trash letters from Field


      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


      Jason Farnsworth