Pick the value and create the flag

Question

I want to create a flag where I will pick the value from the account number to the total

Input:

ABCltd  corp       Account numberpurchasesell123123.15459456452145.2312478978932159.25147.2335159149Total:1628.41689.46      notes:

Output:

ABCltd 0 corp 0   0   0Account numberpurchasesell1123123.154591456452145.231124789789132159.25147.231351591491Total:1628.41689.461   0   0notes:   0

Felipe_Ribeir0 · Answer

Hi @Sshasnk

One way of doing this

Pick the value and create the flag.yxmd

KrishnaChithrathil · Answer

@Sshasnk

you can try this way as well.

Flag it.yxmd

DataNath · Answer

How does this look, @Sshasnk? We're just looking for the presence of 'Account Number' or 'Total:' in Field1 and starting/ending the Flag accordingly:

Add Flag based on Account Number.yxmd