Separate records.

[olguita2014]

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            

[luismadriz]

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

[luismadriz · Accepted solution]

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;

[luismadriz]

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

Regards,

Luis