Create a new field with the field values based upon the string search in another field.

[cheburashka]

Hello,

I would like to change the field value of the field 'Classificatie' if another field ' [Naam v/d tegenpartij :] ' contains a specific string.

How to check if the field ' [Naam v/d tegenpartij :] '  contains 'DATS' or 'totop' ? I tried the following code:

If( WildMatch([Naam v/d tegenpartij :], '*DATS*', '*totop*' ) , 'Tanken', 'Geen' );

But there is a red line under the comma before Tanken. So what is wrong?

How to change the field value of 'Classificatie' of the table [Transacties] based on the above if function?.

,Thx for your help.

Message was edited by: Koen Bal

[#2 · Accepted solution]

Hi Koen,

This can be solved by modifying the mappingwithwildcards.qvw.

Which can be found in Rob Wunderlichs Cookbook (http://robwunderlich.com/downloads/).

kind regards,

Dion