Set Field 2 with Values of Field 1

[Tom8558]

 

Hey,

If the Field "Buchungstext" contains the numbers '699993' or '699994' (only those two),  then i want the field "BS" to be replaced with that number. Is there some way to make it possible?

[MatheusC]

Hi, @Tom8558 

Try it like this:

if(KeepChar(Buchungstext,'699993')='699993','699993',

if(KeepChar(Buchungstext,'699994')='699994','699994',

BS))

Att,
Matheus

[MatheusC]

@Tom8558 

Managed to solve?

close the topic with the accepted solution

Thanks

[sidhiq91]

@Tom8558  Use the below script in your Editor:

NoConcatenate
Temp:
Load * Inline [
Aritkel,Buchungstext,BS
1000118,977924 100710ORS,WE
10001917,699993 5002607 large, RE
10001918,699994 5002607 large, KE
1000239,kasse:87, XKAS

] (delimiter is ',');

NoConcatenate
Temp1:
Load Aritkel,BS,
if(wildMatch(Buchungstext,'*699993*','*699994*'),BS,Buchungstext) as Buchungstext
Resident Temp;

Drop table Temp;

Exit Script;

If this resolves your issue, please like and accept it as a solution.