how to duplicate field and have the new field display only wanted records

[#1]

Hi, I want to duplicate an existing field called DESCRIPTION and name the duplicated field 'description' and I only want 'decscription' to display descriptions which start with 'U' and 'u'. How do I do this? Thanks.

[#2]

LOAD IF(LEFT(DESCRIPTION,1)='U' OR LEFT(DESCRIPTION,1)='u',DESCRIPTION,NULL()) AS description

RESIDENT......

[anbu1984 · Accepted solution]

DESCRIPTION and name the duplicated field 'description'

Load *,If(Upper(DESCRIPTION) like 'U*',DESCRIPTION) as description Resident tab;

Or

Load *,If(DESCRIPTION like 'U*' Or DESCRIPTION like 'u*',DESCRIPTION) as description Resident tab;

Or

Load *,If(WildMatch(DESCRIPTION,'U*'),DESCRIPTION) as description Resident tab;

[#4]

I used your 2nd statement but now 'description' has blank records and descriptions which start with 'U' and 'u'. How do I remove those blank records? Thanks.

[#5]

Use WHERE NOT ISNULL(If(DESCRIPTION like 'U*' Or DESCRIPTION like 'u*',DESCRIPTION));

[preminqlik]

Load *

where not isnull(NewDescription);

Load *,

if(left(capitalize(trim(DESCRIPTION)),1)='U','Description')          as          NewDescription

from path;

[anbu1984]

Tab1:

Load *,If(DESCRIPTION like 'U*' Or DESCRIPTION like 'u*',DESCRIPTION) as description Resident tab;

Final:

Load * Resident Tab1 Where Not(IsNull(description));