Pick the value and create the flag

[Sshasnk]

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

Input: 

ABC	ltd
	corp
Account number	purchase	sell
123	123.15	459
456	452	145.23
124	789	789
32	159.25	147.23
35	159	149
Total:	1628.4	1689.46
notes:

Output:

ABC	ltd		0
	corp		0
			0
			0
Account number	purchase	sell	1
123	123.15	459	1
456	452	145.23	1
124	789	789	1
32	159.25	147.23	1
35	159	149	1
Total:	1628.4	1689.46	1
			0
			0
notes:			0

[DataNath]

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:

[KrishnaChithrathil]

@Sshasnk 

you can try this way as well.

[Felipe_Ribeir0]

Hi @Sshasnk 

One way of doing this