Problem with syntax in resident load

[Anonymous]

Hi all,

I have a problem with the syntax in the given data.

I want to make a resident load with a where-statement, but the syntax leads to a wrong result:

Liste1:

Load *

Resident  Testliste

where wildmatch(Projektbaum,''Car / Bike');               //"Car / Bike" = should be like one word

Liste2:

Load *

Resident  Testliste

where wildmatch(Projektbaum,''Haus / Baum');           //"Haus / Baum" = should be like one word

The / leads to a problem as there are wrong results for both lists=> I can't change the syntax as it is needed later in this way.

Do you have any idea how to solve that problem?

Thank you very much!

[Anonymous]

Thank you for all your help:

The problem was that there were 2 mistakes:

1) in one sentence I didn't use single quote

2) there was an doubled sentenced with both (Car/Bike and Baum/Haus) in the given data => had to correct the delivering system.

Now is works => Thank you so much!