elyse0

[A-Z][A,E,I,O,U,X][A-Z]{2}[0-9]{2}[0-1][0-9][0-3][0-9][M,H][A-Z]{2}[B,C,D,F,G,H,J,K,L,M,N,Ñ,P,Q,R,S,T,V,W,X,Y,Z]{3}[0-9,A-Z][0-9] 

elyse0

use colegio

db.alumnos.aggregate([
    {$lookup: {
            from: "alumnosEvalQueretaro",
            localField: "clave_alu",
            foreignField: "matricula",
            as: "evaluacionesAlumnos"
        }
    },

elyse0

use colegio

db.alumnos.aggregate([
    {$unwind: "$evaluaciones"},
    {$match: {ciudad: "QUERETARO"}},
    {$group: {_id: {
                claveAlu: "$clave_alu",
                nombre: {$concat: ["$nombre", " ", "$ap_paterno", " ", "$ap_materno"]},
            },
            primeraCalif: {$first: "$evaluaciones.calificacion"},

elyse0

db.alumnos.find({
    materias: {$all: ["ESPAÑOL", "MATEMATIACS", "ETICA"]}
}).count();

db.alumnos.find({
    materias: {
        $elemMatch: {
            $in: ["ES", "MAT", "ETICA"]
        }
    }

elyse0

use colegio

db.alumnos.aggregate([
    {$match: {
            evaluaciones: {$exists: 1}
        }
    },
    {$project: {
            _id: 0,
            nombre: {$concat: ["$nombre", " ", "$ap_paterno", " ", "$ap_materno"]},

elyse0

Sub DeleteRowsOnSelectedRangeThatMatch()

    Application.ScreenUpdating = False
    
    Dim SelectedRange As Range
    Set SelectedRange = Selection
    
    RowCount = SelectedRange.Rows.Count
    
    FirstRowIndex = CInt(Split(SelectedRange.Cells(1).Address, "$")(2))

elyse0

Function IsDate(cellValue) As Boolean
    If Len(cellValue) > 9 Then
        IsDate = True
    Else
        IsDate = False
    End If
End Function

Sub SetDates()

elyse0

sudo apt install ibus
ibus-setup
sudo reboot

elyse0

[
  {
    "errors": [
      {
        "message": "PersistedQueryNotFound"
      }
    ],
    "extensions": {
      "durationMilliseconds": 3,
      "operationName": "VideoMetadata",