String Function to Exclude

[#1]

num	name
1	Abc1234
2	cghtry
3	rxyqwret
4	XXXqwwu
5	XXXtyyy
6	XXX1234

Hi,

I have a resident table which has a column name.I need to create a new table excluding name that starts with XXX.How to do it?

New table

Name
Abc1234
cghtry
rxyqwret

Thanks...

[#2 · Accepted solution]

Hi Pooja,

try this

load

     num,

     name

resident table1 where not wildmatch(name,'XXX*');

this will give you all the names which does not start with XXX;

table1 here is your original table, which you have already loaded. change this to your table name.

let me know, if you face any issue.

........

regards,

Ashutosh

[#3]

Thank You so much Ashutosh..It worked.