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

    Cleaning Trash letters from Field

    Jason_Farnsworth

      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