bfac | automated tool that checks for backup artifacts | Security library

I got 2 tabs in excel and i am kinda new to VBA:

"Operations":

"Details":

You can download the workbook and sampledata from here: Workbook

My CODE actually does this:

1. VBA SHOULD FIND EVERY TRANSACTION INSIDE "DESCRIPTION" CELL FROM TAB "OPERATIONS". IN THIS CASE THE FIRST ROW CONTAINS ONE TRANSACTION, ROW 2 CONTAINS ONE TRANSACTION AND ROW 3 CONTAINS 2 TRANSACTIONS AND ONLY CONSIDER THE OPERATION CODES WITHIN 11 DIGITS

2. IT SHOULD COPY THE NUMBER FROM TAB "OPERATIONS" AND PASTE IT INSIDE COLUMN "LINKED" FROM TAB "DESCRIPTION"

3. FIND ALL THE REPEATED VALUES INSIDE "DESCRIPTION" FIELD, I MEAN THOSE VALUES WITH SAME DESCRIPTION AND TYPE: FAC and N/C AND PERFORM THIS:

IF THE REPEATED VALUES CONTAIN A TYPE "FC" AND "N/C" IT MUST PUT THE VALUE OF THE CELL "NUMBER" FROM TAB "OPERATIONS" OF TYPE "N/C" AND PLACE IT INSIDE "LINKED" COLUMN FROM TAB "DETAILS" AND THEN, WRITE WORD: "DONE" INSIDE "NOTE" FIELD AND FINALLY COPY THE VALUE OF CELL "MONEY" FROM TAB "DETAILS" AND PASTE IT INSIDE CELL "MONEY" FROM TAB "OPERATIONS"

After running my code i got this:

The thing is that after pasting the value inside column MONEY from tab OPERATIONS i want to copy the NUMBER of the N/C and paste it inside column LINKED from tab DETAILS for that specific operation number.

Take a look, this is the expected result:

VBA code (a macro) in excel:

So what I am attemping to do is filter some data through a csv from a csv and when it goes through it searches the column and give me all the values that have a matching value in the 2nd CSV from the 1st one. However the values its giving are the groups when in fact I need the devices that are in the groups. So kinda like a group of object inside of an object.

I have a Person entity with a @ManyToOne self-relationship named "manager". In most cases, I do not need to know the Person's manager, so I've marked the relationship with Fetch.LAZY. However, in every case where I retrieve an entity with a Person field, JPA (with Hibernate Provider) loads the referenced Person...and that person's manager...and that person's manager, and so on recursively, until the entire management chain is loaded. All those queries are executed before TypedQuery.getResultList() returns control to my code, so it's not a matter of me inadvertently referencing the manager somewhere in the session and triggering a true lazy load. It appears the JPA fetch plan has determined that the whole management chain is necessary for some reason and loads them all.

I'm using JPA persistence-api 2.2 and hibernate-core 5.4.20

Here's an abbreviation of the Person class:

I have been able to generate the all permutation of length 4 from a string, the problem that I am facing now is that all the permutation have duplicates like {abcd) ,{adbc},{bcda}...which are all same as from Mathematical definition of set.

Is there a short version in java-8 where I can get the pure set?

My code that generated the all permutation: