epjuan21

Sub DeleteRow()

    Application.ScreenUpdating = False
    
    'Columna donse se ecuentra el criterio
    'Column where the criterion is found
    Col = 7 
    
    'We set the criteria
    'Establecemos el Criterio

epjuan21

añadir permisos al archivo .pem
    chmod 400 <pem>

añadir el archivo .pem  a tus claves
    ssh-add -K <pem>

acceso ssh a nuestro servidor
    ssh -i <pem>.pem ubuntu@<ip>

actualizar repositorios con apt-get

epjuan21

## Instalar Laravel 5.7 en Windows Server 2012 R2 Sobre Internet Information Services

  # Nos ubicamos en la carpeta de IIS C:\inetpub\wwwroot

  # Ejecutamos el siguiente comando en la terminal

  composer create-project --prefer-dist laravel/laravel blog "5.7.*"
    
## Configurar el Proyecto en IIS

epjuan21

// Remove Duplicates From Array
var fruits = [“banana”, “apple”, “orange”, “watermelon”, “apple”, “orange”, “grape”, “apple”];

// First method
var uniqueFruits = Array.from(new Set(fruits));
console.log(uniqueFruits); // returns [“banana”, “apple”, “orange”, “watermelon”, “grape”]
// Second method
var uniqueFruits2 = […new Set(fruits)];
console.log(uniqueFruits2); // returns [“banana”, “apple”, “orange”, “watermelon”, “grape”]

epjuan21

//Replace the specific value in an array

var fruits = [“banana”, “apple”, “orange”, “watermelon”, “apple”, “orange”, “grape”, “apple”];
fruits.splice(0, 2, “potato”, “tomato”);
console.log(fruits); // returns [“potato”, “tomato”, “orange”, “watermelon”, “apple”, “orange”, “grape”, “apple”]

epjuan21

// Map array without .map()

var friends = [
    { name: ‘John’, age: 22 },
    { name: ‘Peter’, age: 23 },
    { name: ‘Mark’, age: 24 },
    { name: ‘Maria’, age: 22 },
    { name: ‘Monica’, age: 21 },
    { name: ‘Martha’, age: 19 },
]

epjuan21

// Empty an array

var fruits = [“banana”, “apple”, “orange”, “watermelon”, “apple”, “orange”, “grape”, “apple”];

fruits.length = 0;
console.log(fruits); // returns []

epjuan21

// Convert array to an object

var fruits = [“banana”, “apple”, “orange”, “watermelon”];
var fruitsObj = { …fruits };
console.log(fruitsObj); // returns {0: “banana”, 1: “apple”, 2: “orange”, 3: “watermelon”, 4: “apple”, 5: “orange”, 6: “grape”, 7: “apple”}

epjuan21

// Fulfill array with data

var newArray = new Array(10).fill(“1”);
console.log(newArray); // returns [“1”, “1”, “1”, “1”, “1”, “1”, “1”, “1”, “1”, “1”, “1”]

epjuan21

//  Merge Arrays

var fruits = [“apple”, “banana”, “orange”];
var meat = [“poultry”, “beef”, “fish”];
var vegetables = [“potato”, “tomato”, “cucumber”];
var food = […fruits, …meat, …vegetables];
console.log(food); // [“apple”, “banana”, “orange”, “poultry”, “beef”, “fish”, “potato”, “tomato”, “cucumber”]