Challenge #188: Difficult, but not im-parse-able
- 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
- 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
Probably a better way to go ! I'll be looking at the solution after this ! 😁
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
oups
sorry my bad !
- 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
Still learning new tools, Regex. Took a long winded route to split into Header set and Details set. For the header set, I noticed below -
| 15 |123-43-92508|#### | 15 | | |1|4|9|1|6|8|1|8|2|9|1|9| | |1|4|9|1|6|8|1|5|8|2|0 | |
VAT ID 123-43-92508 has 15 transactions but the line details under it has only 9 rows. Maybe I need to extract the Total amount from the header of |1|4|9|1|6|8|1|8|2|9|1|9| and match to the summary total of rows appearing below.
Overall a great learning start for my journey towards Advanced certification.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I admit this was quite a challenge to untangle :) Thank you, @AYXAcademy
I followed a similar approach as in the solution provided.
- 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
Regex for the win! Prefer dates to be date fields, so solution isn't an exact match.