1 Reply Latest reply: Mar 17, 2012 12:36 AM by Sokkorn Cheav RSS

    Split Data

    ravi gupta

      Please anyone can help me to split data then check data:

       

      Example:  2 y,3 m

                     3 y, 4 m

       

      then how to check.

       

      Data attached,please check?

      Please help any one?

        • Split Data
          Sokkorn Cheav

          Hi,

           

          Not sure this one you looking for

          CodeNameDOBDOJGRADEDESIGNATIONDEPARTMENTLOCATIONM / FRelv. ExperienceF1F2
          C010091Vinay Kumar Sharma20-Jul-7412-Feb-97G4Assistant Manager FinanceFINANCENCRM14 Y, 11 M14 Y11 M
          C010967Pradeep Kumar9-May-8115-Nov-06G3Senior Accounts ExecutiveFINANCENCRM6 Y, 7 M6 Y7 M
          C011162Devender Pal2-Jun-861-Jan-08G2Accounts ExecutiveFINANCENCRM8 Y, 4 M8 Y4 M

           

           

          I added two field (F1 and F2). If this one is you looking for then try two ways to get this done:

          1. Load

          LOAD

               SubField([Relv. Experience],',',1) AS [F1],

               SubField([Relv. Experience],',',2) AS [F2],

           

          2. Use expression

               SubField([Relv. Experience],',',1)

               SubField([Relv. Experience],',',2)

           

          Regards,

          Sokkorn