3 Replies Latest reply on Nov 15, 2018 2:11 AM by Norbert Maijoor

    Replacing fields in columns

    Kres Ang

      Hi,  I am trying to clean my data. However, i have difficulties trying to replace the fields. I need to change XXX to AA. Then it goes on to XXX to BB Thank you.

      E.g.

      Card   Status

      AA      Card

      XXX    Door Open

      XXX    Door close

      BB      Card

      XXX    Door Open

      XXX    Door close