3 Replies Latest reply: Oct 23, 2017 7:12 PM by Luis Madriz RSS

    Separate records.

    olga avalos

      Hi,

       

      Please help me!!!!..

       

      I want to separate records from data field like capital letters and lowercase, How can I do this?... for example:

       

       

      Data Field:

       

                                Names

      Records:          ANA

                               Mary

                              

       

      Then the result is:

                                                   Names1 (capital letters)

                                                    ANA

       

                                                   Names2 (lowercase)

                                                   Mary            

        • Re: Separate records.
          Luis Madriz

          Hola Olga,

           

          How about this?

          Employees:

          Load * Inline

            [Employee,

          'Bob'

          'MARK'

          'Steve'

          'Mary'

          ];

           

          Cases:

            Load 

              *,

              if(Upper(Employee)=Employee,Employee) as Uppercase,

              if(Upper(Employee)<>Employee,Employee) as Lowercase

            Resident Employees;

            Drop Table Employees;

           

          Saludos

           

          Luis

          • Re: Separate records.
            Luis Madriz

            En caso que quieras generar diferentes tablas:

             

            Employees:

            Load * Inline

              [Employee,

            'Bob'

            'MARK'

            'Steve'

            'Mary'

            ];

             

             

            Cases:

              Load

                *,

                if(Upper(Employee)=Employee,1,0) as Uppercase

            Resident Employees;

            Drop Table Employees;

             

            Names1:

            NoConcatenate

            Load Employee

            Resident Cases

            Where Uppercase = 1;

             

             

            Names2:

            NoConcatenate

            Load Employee

            Resident Cases

            Where Uppercase = 0;

             

             

            Drop Table Cases;

            • Re: Separate records.
              Luis Madriz

              Hi Olga, did you try the code I sent you? did it work for you? please let me know,

               

              Regards,

               

              Luis