Skip to content

Instantly share code, notes, and snippets.

View rdapaz's full-sized avatar

ricdeez rdapaz

View GitHub Profile
@rdapaz
rdapaz / visioUpdater.py
Created January 14, 2021 23:53
Visio Updater
import os
import win32com.client
import re
import pprint
def pretty_print(o):
pp = pprint.PrettyPrinter(indent=4)
pp.pprint(o)
@rdapaz
rdapaz / Hashmania.py
Created February 11, 2021 00:30
Clever data munging with hashes
abbrevs = [
'STP',
'TCP',
'TI',
'USB',
'UTP',
'VLAN',
'VLANs',
'VM',
'VMs',
@rdapaz
rdapaz / .gitignore
Created February 12, 2021 07:42 — forked from bradley219/.gitignore
PID C++ implementation
.DS_Store
#1 import these classes from jinja2 module
from jinja2 import FileSystemLoader, Environment, Template
from pathlib import Path
from enum import Enum
import re, sys, os
port_data = """
Gi2/0/23|Gi2/0/23: Desc1|130
Gi2/0/21|Gi2/0/21: Desc2|120
@rdapaz
rdapaz / Using_robocopy.md
Created May 25, 2021 01:30
Robocopy Usage to backup folder

Robocopy usage

robocopy <source folder> <destination archive> /e /z /r:1 /w:1

Where:

  • /e recurses
  • /z allows you to restart copy from last time
  • /r:1 retries set to 1
@rdapaz
rdapaz / gist:06b6fe7ea8ac80043c0ea44b5020b6d8
Created June 27, 2021 00:49 — forked from ricdeez/gist:4167831
Ruby: Manipulate MSWord Docs
%w(pp win32ole).each {|dep| require dep}
begin
$app = WIN32OLE.connect('Word.Application')
rescue Exception => e
$app = WIN32OLE.new('Word.Application')
end
$app.Visible = true
class WordConst
@rdapaz
rdapaz / enemyofsomeonewhoisownworstenemy.md
Created June 27, 2021 00:53
Enemy of someone who is own worst enemy

Jim is my enemy - but it turns out that Jim is also his own worst enemy - and the enemy of my enemy is my friend - so Jim is actually my friend - but - because he is his own worst enemy - the enemy of my friend is my enemy - so Jim is actually my enemy - but...

@rdapaz
rdapaz / databaseimport.rb
Created June 27, 2021 00:56 — forked from ricdeez/databaseimport.rb
Ruby Import data to Access from Excel
%w(pp win32ole).each { |dep| require dep }
db = 'C:\Users\rdapaz\Documents\Statement of Compliance.accdb'
cs = "Provider=Microsoft.ACE.OLEDB.12.0; Data Source=#{db};"
rs = WIN32OLE.new('ADODB.Recordset')
conn = WIN32OLE.new('ADODB.Connection')
conn.Open(cs)
rs.Open("[SoC]", conn, 1, 3)
conn.Execute("DELETE * FROM SoC")
@rdapaz
rdapaz / Re-numberTableIndexColumnsInWord.py
Created June 28, 2021 02:22
Re-Number Table Index Columns in Word
# AFQ210311450994
import re
import win32com.client as w32
path = r'<path goes here>'
wdApp = w32.gencache.EnsureDispatch('Word.Application')
wdApp.Visible = True
doc = wdApp.Documents.Open(path)
@rdapaz
rdapaz / hex.py
Created August 31, 2021 07:31
Hex
def strHex(s):
return f"0x%0.2X" % s
strHex(3)