7 Replies Latest reply: Nov 29, 2013 3:57 AM by Ralf Becher RSS

    Data filtering_1

      Hi Experts,

       

      Have data in below manner as shown in Col: "A", need the resul as shown in Col: "B", where last Alphabets after second slash "/" denotes

      N for 1

      S for 2

      E for 3

       

      pls need your expert advice.

       

       

      AB
      FUZ-JONA / 00746 / NFUZ007461
      HLE-MSC UGANDA / 00334 / SHLE003342
      FKA-COPIHUE / 00010 / SFKA000102
      FG9-NYK THESEUS / 00027 / EFG9000271
      EOW-CMA CGM TOSCA / 01331 / SEOW013312
      HTV-VEGA / 00751 / SHTV007512
      FJP-AS CATALANIA / 00008 / SFJP000082
      FWB-HUDSON RIVER / 00571 / SFWB005712
      FWD-HEBE / 00003 / EFWD000031
      FFB-RHL AGILITAS / 00744 / NFFB007441
      FAR-MSC MADRID / 00334 / SFAR003342

       

      FFR-SANTA CATARINA / 00330 / N

      FFR003301