6 Replies Latest reply: Mar 5, 2015 11:25 AM by Rob Wunderlich RSS

    Trim,PuregChar or Subfield

      Hi

       

      I have some Data as follows:

       

      X123

      A09X

      K85X

      A12 D

      B56 A

       

      I am trying to tidy the data to resemble

       

      X123

      A09

      K85

      A12

      B56

       

      By using PurgChar it removes all The X,D & A's which is not my desired result.

       

      Can anyone suggest a successful way of doing this?

       

      Thanks