filter load table

[bilionut]

Hi,

I guess it's elementary stuff but I fail to find the correct solution

From a table like this:

KEY	Name
1	Abhgh UIUjkj#
2	Akljhka
3	JHKGHJG #
4	Kljijihh#
5	Abhgh

I want to load only the rows that contain the '#' character in field Name

Thanks,

Ionut

[swuehl · Accepted solution]

Is '#' always the last character, when contained in the record?

LOAD KEY, Name FROM Table.xls WHERE RIGHT(Name,1) = '#';

or use a search

LOAD KEY, Name FROM Table.xls WHERE Name LIKE '*#*';

[its_anandrjs]

You can use Wildmatch() also see the load script

Source:

LOAD * Inline

[

KEY, Name

1, Abhgh UIUjkj#

2, Akljhka

3, JHKGHJG #

4, Kljijihh#

5, Abhgh

];

NewTable:

NoConcatenate

LOAD

KEY,Name

Resident Source

WHERE WildMatch(Name,'*#*');

DROP Table Source;