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

[martin59]

Hi,

I'm not sure to understand as well. Could you send us your entire script ?

But you can't do that if you're not in a Load statement.

Hope that helps you,

Martin Favier

[martin59]

Hi,

I'm not sure to understand as well. Could you send us your entire script ?

But you can't do that if you're not in a Load statement.

Hope that helps you,

Martin Favier

[martin59]

Hi,

I'm not sure to understand as well. Could you send us your entire script ?

But you can't do that if you're not in a Load statement.

Hope that helps you,

Martin Favier

[martin59]

Hi,

I'm not sure to understand as well. Could you send us your entire script ?

But you can't do that if you're not in a Load statement.

Hope that helps you,

Martin Favier

[martin59]

Hi,

I'm not sure to understand as well. Could you send us your entire script ?

But you can't do that if you're not in a Load statement.

Hope that helps you,

Martin Favier

[cheburashka]

I added My script in the question attachment.

[Gysbert_Wassenaar]

Since you're using the qvc library, have a look at the CreateWildmapExpression.qvw example. That's what you're going to need. And you'll have to do it in a load statement. You can't use 'loose' statements in your script to change data in a table.

[cheburashka]

Hello,

Thx I'll check the CreateWildmapExpression.qvw .

So can I reload a table I've loaded earlier in the script and then start changing values of the 'classificatie field' based upon the values of the field '[Naam v/d tegenpartij :]' ?

Or how should I do it?

[cheburashka]

Can you please remove your multiple copies of yout answer. thx

-Koen