deyvicode

Sub LoopThroughFiles()
    Debug.Print ""
    Debug.Print "-------------------------------------------------"
    
    
    Dim oFSO As Object
    Dim oFolder As Object
    Dim oFile As Object
    Dim i As Integer
    

deyvicode

Sub consolidate()
    
    Dim Destiny As Workbook
    Set Destiny = ThisWorkbook
    
    Dim Data As Workbook
    Dim Path As String
    
    Dim mrs As Variant
    mrs = Array( _

deyvicode

Sub Test()
    
    'declarar variables
    Dim wb As Workbook
    Dim ThisSheet As Worksheet
    Dim NumOfColumns As Integer
    Dim RangeToCopy As Range
    Dim RangeOfHeader As Range
    Dim WorkbookCounter As Integer
    Dim RowsInFile

deyvicode

Private Sub BoxSearch_Change()
    Dim text As String
    If Sheet1.BoxSearch.value <> "" Then
        text = "*" & Sheet1.BoxSearch.value & "*"
        Range("A3").CurrentRegion.AutoFilter Field:=3, Criteria1:=text
    Else
        text = ""
        Range("A3").CurrentRegion.AutoFilter
    End If
End Sub

deyvicode

const format = (date, locale, options) => new Intl.DateTimeFormat(locale, options).format(date)

const now = new Date()

format(now, 'es') // '8/1/2022'
format(now, 'es', { dateStyle: 'long' }) // '8 de enero de 2022'
format(now, 'es', { timeStyle: 'short' }) // '8:13'
format(now, 'ko') // '2022. 1. 8.'
format(now, 'en', { weekday: 'short', day: 'numeric' }) // '5 Wed'

deyvicode

SELECT JSON_ARRAYAGG(JSON_OBJECT(
'name', name,
'address', address
)) 
FROM mybd.mytable
INTO OUTFILE '\path\users.json';

deyvicode

Personalización del la terminal en windows con:

• PowerShell
• Oh-my-posh
• Fluent Terminal

deyvicode

class Course {
    
    constructor(private _id: number, private _name: string) {}

    // get and set
    
    get id() {
        return this._id
    }

deyvicode

$('#table').DataTable({
  'processing': true,
  'serverSide': true,
  'destroy': true,
  'ajax': {
    'url': '/route',
    'type': 'GET'
  },
  'columns': [
    { data: 'column1' },

deyvicode

// use DB;
// use Log;

try {
  DB::beginTransaction();

  // code

  DB::commit();
} catch (\PDOException $e) {