topic Set Field 2 with Values of Field 1 in App Development

Set Field 2 with Values of Field 1

Tom8558 — Mon, 04 Dec 2023 12:20:46 GMT

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?

Re: Set Field 2 with Values of Field 1

MatheusC — Mon, 04 Dec 2023 12:57:32 GMT

Hi, @Tom8558

Try it like this:

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

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

BS))

Att,
Matheus

Re: Set Field 2 with Values of Field 1

MatheusC — Wed, 06 Dec 2023 11:40:37 GMT

@Tom8558

Managed to solve?

close the topic with the accepted solution

Thanks

Re: Set Field 2 with Values of Field 1

sidhiq91 — Wed, 06 Dec 2023 12:07:55 GMT

@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.