bertspaan

Python script to convert DBF database file to CSV

• First download dbfpy: http://sourceforge.net/projects/dbfpy/files/latest/download?source=files
• Then install: sudo python setup.py install

To convert DBF file to CSV:

./dbf2csv database.dbf

mkropat

function Add-EnvPath {
    param(
        [Parameter(Mandatory=$true)]
        [string] $Path,

        [ValidateSet('Machine', 'User', 'Session')]
        [string] $Container = 'Session'
    )

    if ($Container -ne 'Session') {

Driste

VirtualBox CLI

Download

# For RHEL 7
yum install VirtualBox-5.1-5.1.14_112924_el7-1.x86_64.rpm

erikvullings

'Change the language of your PowerPoint
'In newer PowerPoint version, you need to first save your PowerPoint with macros enabled.
'Go to the VIEW tab, select MACROS (at the right), enter a name, e.g. toEnglish, and press create to enter below text.
'Now you can run the macro from the same menu.
'Alternatively, but less complete, go to the VIEW tab, select OUTLINE, select all slides (using CTRL-A).
'Now go to the REVIEW tab, select Language, and change the proofing language.
'Also make sure that you set the WINDOWS Language (taskbar, bottom right) to the preferred language, otherwise all new text
'will have the same problem (Press CTRL + WINDOWS + SPACE to switch the Keyboard input language).
Option Explicit
Sub toEnglish()

Aldaviva

Easy PowerShell Remoting

PowerShell Remoting allows you to connect to a remote shell on another Windows computer.

The server is the Windows computer that will host the shell, and that you will connect to. The client is the Windows computer that will create the connection, on which you will see and interact with the shell.

These steps assume a workgroup with Windows 10 or Server 2016 or later on the server, and Windows 7 or later on the client. It assumes that the client is running with a user account that also exists on the server with the same password. Neither the server nor the client need to be joined to a domain or using Kerberos.

Prerequisites

G33kDude

#NoEnv
SetBatchLines, -1

#Include <Socket>

MATRIC_CONFIG_PATH := A_Desktop "\..\Documents\.matric\config.json"
APP_NAME := "AutoHotkey"
API_PORT := 50300
RESP_PORT := 50301

ExcelExciting

/*
TIRED OF WRITING EXCEL FORMULA AGAIN AND AGAIN, WELL EXPORT THIS LAMBDA LINK INTO YOU EXCEL WORKBOOK AND ENJOY THE USING THE CODE. DON'T FORGET THE SHARE AND LIKE.
EACH LAMBDA IS CREATED BY DIFFERENT AUTHOR, PLEASE REFER TO DETAILS WITHIN EACH FORMULA
*/

/*
--------------------- HIJRI AGE CALCULATOR ---------------------
*/
HIJRIAGE =
/*Hijri Age Calculator allows you to calculate the age of person as per arabic calander.

cwas101

//All in 1 change formulas, EXCEPT EARNINGS RATIO------------------
//New is the column with the most recent values
//Old is the column with the older values
Change=
LAMBDA(
    NEW, OLD,
   IFERROR(IF(AND(LEFT(CELL("format",NEW),1)="P", LEFT(CELL("format",OLD),1)="P"),
NEW-OLD,

ExcelRobot

/*
Excel Array Manipulation LAMBDA functions
Courtesy of Excel Robot

The Microsoft Excel team recent released 11 new Excel functions for combining, shaping, and resizing arrays.
I had already created similar ones for myself using the amazing LAMBDA function.  Since the new functions
are only available to users running Beta Channel, I've renamed my versions and given them the same function 
names so anyone with LAMBDA and LAMBDA helper functions (like MAKEARRAY), and import these LAMBDAs into your
workbook and have nearly the same functionality.

ncalm

/*
array is a column of stuff to which we want to apply element function
row_function is some function that produces an array with a fixed number of columns
  the column count produced by row_function must be identical regardless of input
stack_function is one of V or H

If you're unsure how these work or why we would use them, please review these videos:
https://youtu.be/04jOeiMypXw
https://youtu.be/wEBLT9QfQRw