Delete specific rows
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I replaced it with "." instead :)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you!
