pQL | PHP ORM - | Object-Relational Mapping library

I need to write a script that connects an ERP program to a manufacturing program. With the production program the matter is clear - I send it data via HTTP requests. It is worse with the ERP program, because in its case, the data must be read from a DBF file.

I use the dbf library because (if I'm not mistaken) it's the only one that provides the ability to filter data in a fairly simple and fast way. I open the database this way

I have lots of recruitment data that i want to re-arrange, separate and modify using arrays. The data includes all information from 1st stage, 2nd stage and 3rd stage interview for each candidates. The idea is to separate each stage onto their own sheets (e.g. Interview 1, interview 2, interview 3). And then to also create a table that has information from all three stages for each candidate.

Firstly, i have created an array of all the data by declaring the range ("A1:AV10000") as a variant.

Then i have created a loop to loop through this data, and separate each type of event that occurs into their own arrays, using an IF function within the loop. If condition is met, create a new array and add each row that condition is met to an array.

However, i believe my arrays are being made into a 3D array and i am sure how to edit the code so that it remains 2Darray. I understand why the code may be creating 3D array (due to iterating by 1 in the loop), however i am unsure how to write code so it includes all data the row and only iterates as shown below.

e.g. currently it goes (1)(1,1),(1)(1,2) then (2)(1,1),(2)(1,2) then (3)(1,1),(3)(1,2). I would think it would work if it was (1,1)(1,2) then (2,1)(2,2) then (3,1)(3,2). Screenshot of array format from local window

I am new to regex. I have a file on Linux with below data. I want to replace the string at position 5th, 7th, 8th .
I am able to replace the data using the below command

I am trying to order custom posts by custom fields. this is my code.

I want to send a specific message using sdkperf in Solace. But I cannot find the cli command for this. Can someone help me?

I'm using a EF with .Net Core 2.2. And I cannot figurated out how to solve the following problem:

I have the PQL and PM fields, these fields are the key of a user (Based in the table User). So, How I can create two relations of two fields to the same field (In the secondary table) using EF...

Example, a requirement is to create a query to get all projects per user, where the user be the PM or the PQL...

The main table is:

I have some code that creates XML differently based on a very simple string of characters. Does anyone know why?

First of all, code snippet ( to clarify things for @mob ), with the lines AROUND the problem line:

I want to set value using declare on trigger. The trigger is as follow:

I have non-normal data (bacteria on fingers after touching surfaces with and without gloves) so using glmmPQL from the MASS package. I have one categorical predictor (Gloves), a repeated measurement variable (NumberContacts) and Participants who did the experiment gloved and ungloved so are crossed. I'd like to use the Participant variable as a random effect with random slope (but not intercept as they have 0 bacteria to start with). I can't figure out the syntax for random effects with random slope but not random intercept. Could you show me how to do this please?

So far I have: