topic Re: Separate records. in App Development

Separate records.

olguita2014 — Thu, 19 Oct 2017 21:58:49 GMT

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.

luismadriz — Fri, 20 Oct 2017 02:17:13 GMT

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.

luismadriz — Fri, 20 Oct 2017 02:33:56 GMT

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.

luismadriz — Mon, 23 Oct 2017 23:12:02 GMT

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

Regards,

Luis