A1 | Bcrypt Authentication for Kohana | Authorization library

Sorry I don't show my variables or anything, tried to give information only pertaining to the questions. This 1 Sub is huge.

Currently my code allows a user to select multiple files, the files selected will be sorted in a specific format, then loaded into 2 different arrays. Currently loads Columns D:E into 1 array and Columns I:K into another array (from selected files QSResultFileWS, and returns those arrays to my destination FormattingWS. I'm still trying to learn arrays so if the methodology I used to do this isn't proper, be gentle.

I am relatively new in dealing with txt and json datasets. I have a dialogue dataset in a txt file and i want to convert it into a csv file with each new line converted into a column. and when the next dialog starts (next paragraph), it starts with a new row. so i get data in format of

I'm trying to parallelize a merge-sort algorithm. What I'm doing is dividing the input array for each thread, then merging the threads results. The way I'm trying to merge the results is something like this:

First time actually using anything to do with swing - sorry for the poor code and crude visuals!
Using swing for a massively over-complicated password checker school project, and when I came to loading in a JMenuBar, it doesn't render properly the first time. Once I run through one of the options first, it reloads correctly, but the first time it comes out like this: First render attempt
But after I run one of the methods, either by clicking one of the buttons that I added to check if it was just the JFrame that was broken or using one of the broken menu options, it reloads correctly, but has a little grey bar above where the JMenuBar actually renders: Post-method render

The code for the visuals is as follows:

I have two google sheets in the same workbook and I am trying to import certain columns from one into the other sheet based on what hour of class was chosen. For example, I have the Date in column A, Name in B, Email in C, and Number in D and other stuff, then the Class in I.

Column A - Date Column B - Name Column C - Email Column D - Number ... Column I - Class

My goal is to import column B through D if column I has a certain class. I tried a using this if statemnt: =if('Confirmação'!I2 = A1,(=importrange("sheet_url","Confirmação!B2:D2")), "NOPE") where A1 has the name of the class to look for, but it resulted in a #Error.

Then I tried a variety of query such as the following: =QUERY({'Confirmação'!B2:D2,'Confirmação'!I2},"Where I = 'Terça 19h English 1'") =QUERY({'Confirmação'!B2:D2, 'Confirmação'!I2},"Where 'Confirmação'!I = 'Terça 19h English 1'")

and also added the IfError: =iferror(QUERY('Confirmação'!B4:I4,"Where I = 'Terça 19h English 1'"),"Vaga")

Could someone correct my functions or help with a google script? Thank you! Very much appreciated! (Sorry about the Portugues-it's a project I am working on in Brazil)

I'd like to return the value of the start and end of a data frame based on the data it contains. Any suggestion is welcomed.

Data structure:

Output:

Sample data:

Dataset looks like this : This is a sample dataset for number of employee login activity named - activity

I need to calculate few metrics, was able to do in python data frames, but new in mySQL.

1. what is the average number of employee active per day for month of jan 2018 by dept ( was able to do somewhat half of it, but results coming are not correct.

2. number of unique active employee (login >0) per month for jan 2018 for each dept_id (was able to do it)

3. month over month growth for all dept_id from dec-2017 to jan 2018 where at least one employee was active (login >0) - no idea how to do this in sql

4. fraction of users who were active in each dept_id for dec 2017 and were also active in the same dept_id for jan 2018

5. how many employee login in on 3 or more consecutive days in jan 2018

Any help would be appreciated.

Query written for case 1:

I am trying to divide merged information from one cell into separate cells.

one cell:

divided data: (I want to export each part into another cell)

I can't simply divide by finding empty space, status cell which is case-sensitive | status:WBB NAS MRR OWA PXA| has a different data range with spaces that can't be divided.

Split ( expression [,delimiter] [,limit] [,compare] )

I'm using express-validator to find out if certain user inputs match specific keywords. If any of the inputs are invalid, a POST request to my db should not be made. If all of the inputs pass, then the POST should go through. The user should be re-directed to a /submitted view when the inputs are valid or invalid.

When none of the inputs are valid, the POST is not made and the db is not updated (which is good, since I don't want the db to have invalid data), but the issue is that the page hangs and never reloads (has to be done manually).

I have an if/else statement below that says what should be done if the data is invalid. The console says that applicant.end() and res.end() are not functions. Is there something else that I can write that'll "stop" the request but do the redirect?