Delete specific rows

[qgpl]

Hello 

I need to delete "Available Funds" and the figure that comes below it, from the screenshot it's currently ****.** and as you can see I have "Balance" and it's figure right below it which I need in my output. 

Throughout my data "Available Funds" disappears so it's a bit inconsistent. I have attached a sample data. 

My expected output (for example) is

COMPANY NAME	COMPANY ACC	BALANCE	CCY
COMPANY LIMITED 1	IE1235678910	****.**	EUR
COMPANY LIMITED 2	IE32154987956	****.**	GBP

I'm nearly there... I just need to get rid of the Available Funds without removing any other data i.e. I need currency and account number to stay so I can't use the Filter function. 

My workflow so far! I'm a complete beginner - please don't judge 😅

Thank you

[ShankerV · Accepted solution]

Hi @qgpl 

One way to remove with the help of Multi row formula.

[qgpl]

Thanks so much @ShankerV  - what do I do if the available funds have figures in it not *?

[qgpl]

I replaced it with "." instead :)

[ShankerV]

Hi @qgpl .

So what will the value in the input file instead of *

As I see the * in the input file, I have applied the logic.

Please replace with the character which is in your latest input file.

[qgpl]

Thank you!