9 Replies Latest reply: Aug 15, 2016 11:55 AM by Виталий Чуприна RSS

    Inconsistent structure of data in column

    Виталий Чуприна

      Good Morning All,

       

      We receive files and one of columns contains style, color and color code information. The problem that data in this column can be placed by different ways, see examples below:

       

       

      ExamplesDescription
      C99ELS007 BLACK
      STYLE COLOR
      C99SE7006-ELKMU-BLACK/MUSLIN
      STYLE TRASH COLOR
      LP61980MQ-BDH-BLACK-WHITE
      STYLE TRASH COLOR
      PR6B700DFG-BC-G4432-J-CDB-CHAMBR
      STYLE TRASH COLOR__CODE TRASH COLOR
      WOMEN-CHAMBR.PR6B700DFG
      TRASH COLOR STYLE
      PO64301PL.IVORY
      STYLE COLOR
      ED6SD05NL/BLK/70
      STYLE COLOR COLOR__CODE
      R263C113E
      STYLE
      MEN R263C343E.OLIVE
      TRASH STYLE COLOR

       

      Do you have any ideas how correctly determine Style, Color code and color description.

       

      Thanks,

      Vitaliy