Skip to content

Latest commit

History

11 Commits

Folders and files

NameName
Last commit message
Last commit date

Repository files navigation

csv-compare-script

Description:

Batch script, using the cmd windows32 system, that can be simply used to generate a merged data file from the comparsion of an old and new CSV data file that contains updated data records from the old file, where the new file contains new data records, as well as, the loss of data records that were on the old file, however, no longer given in the new file. The primary purpose of this script is to carry over additional text that may be noted on the old file, such as: a column for sales notes, to the matching record on the new file, which would not contain any of the prior notes. Therefore, by using this script a newly generated file can be created that contains all the fixes made to the old file paired with the most up-to-date data of the new file.

Usage:

  • Windows Operating System

The script should be placed in the same directory as both the old csv file - which does not need to follow any naming convention - and the new csv file - which at the current status of the script must be named "new.csv". The directory should only contain these two csv files, as any other csv files within the same directory will also be read in as the old file. The compare.cmd file is executable as is, and does not require any user input. The series of tokenisation patterns can be changed to fit different shaped datasets, the current shape of the test datasets, which this script is designed for, can be found in another of my git repo's (csv_gen.py): https://github.com/christopher-christofi/random-file-dataset-generator. columns: blank (index), unique id, date, time, text, integer, blank (text); the shape of the generated dataset, is as follows: unique id, time, text, integer, blank (text). The name of the generated dataset will be "complete.csv". The intended carry over text found only in the old file is of the last column, blank and without header.

About

Collates and reintegrates edits and updates on an old csv sheet inline to the exitsing data values of a newly recieved data sheet

Topics

Resources

Stars

0 stars

Watchers

1 watching

Forks

Contributors

Languages

, 'i'); if (__m === '*' || __re.test(location.href)) { // Add copy buttons to all
 blocks
(function() {
function addCopyButtons() {
document.querySelectorAll('pre code').forEach(function(codeBlock) {
if (codeBlock.parentElement.hasAttribute('data-copy-added')) return;
codeBlock.parentElement.setAttribute('data-copy-added', 'true');
var btn = document.createElement('button');
btn.textContent = 'Copy';
btn.style.cssText = 'position:absolute;top:4px;right:4px;padding:2px 8px;font-size:11px;background:#4ecdc4;border:none;border-radius:4px;color:#1a1a2e;cursor:pointer;opacity:0.7;transition:opacity 0.2s;';
btn.onmouseover = function() { this.style.opacity = '1'; };
btn.onmouseout = function() { this.style.opacity = '0.7'; };
btn.onclick = function() {
navigator.clipboard.writeText(codeBlock.textContent).then(function() {
btn.textContent = 'Copied!';
setTimeout(function() { btn.textContent = 'Copy'; }, 1500);
});
};
codeBlock.parentElement.style.position = 'relative';
codeBlock.parentElement.appendChild(btn);
});
}
addCopyButtons();
// Re-run on dynamic content
var observer = new MutationObserver(addCopyButtons);
observer.observe(document.body, { childList: true, subtree: true });
})();
}
} catch(__e) { console.warn('[Userscript:Add Copy Buttons to Code Blocks]', __e); }
})();
(function(){
try {
var __m = "github.com";
var __re = new RegExp('^' + "github\\.com" + '
GitHub - ChristopherChristofi/csv-compare-script: Collates and reintegrates edits and updates on an old csv sheet inline to the exitsing data values of a newly recieved data sheet · GitHub
Skip to content

Latest commit

History

11 Commits

Folders and files

NameName
Last commit message
Last commit date

Repository files navigation

csv-compare-script

Description:

Batch script, using the cmd windows32 system, that can be simply used to generate a merged data file from the comparsion of an old and new CSV data file that contains updated data records from the old file, where the new file contains new data records, as well as, the loss of data records that were on the old file, however, no longer given in the new file. The primary purpose of this script is to carry over additional text that may be noted on the old file, such as: a column for sales notes, to the matching record on the new file, which would not contain any of the prior notes. Therefore, by using this script a newly generated file can be created that contains all the fixes made to the old file paired with the most up-to-date data of the new file.

Usage:

  • Windows Operating System

The script should be placed in the same directory as both the old csv file - which does not need to follow any naming convention - and the new csv file - which at the current status of the script must be named "new.csv". The directory should only contain these two csv files, as any other csv files within the same directory will also be read in as the old file. The compare.cmd file is executable as is, and does not require any user input. The series of tokenisation patterns can be changed to fit different shaped datasets, the current shape of the test datasets, which this script is designed for, can be found in another of my git repo's (csv_gen.py): https://github.com/christopher-christofi/random-file-dataset-generator. columns: blank (index), unique id, date, time, text, integer, blank (text); the shape of the generated dataset, is as follows: unique id, time, text, integer, blank (text). The name of the generated dataset will be "complete.csv". The intended carry over text found only in the old file is of the last column, blank and without header.

About

Collates and reintegrates edits and updates on an old csv sheet inline to the exitsing data values of a newly recieved data sheet

Topics

Resources

Stars

0 stars

Watchers

1 watching

Forks

Contributors

Languages

, 'i'); if (__m === '*' || __re.test(location.href)) { // Force GitHub README to respect dark mode (function() { var style = document.createElement('style'); style.textContent = ' .markdown-body { color-scheme: dark light; } .markdown-body pre { background: #161b22 !important; } .markdown-body code { background: rgba(110, 118, 129, 0.4) !important; } .markdown-body table th, .markdown-body table td { border-color: #30363d !important; } .markdown-body img { background: #0d1117; } .markdown-body blockquote { border-left-color: #8b949e; } .markdown-body hr { border-color: #30363d; } '; document.head.appendChild(style); })(); } } catch(__e) { console.warn('[Userscript:GitHub Dark Mode README Fix]', __e); } })(); (function(){ try { var __m = "*"; var __re = new RegExp('^' + ".*" + ' GitHub - ChristopherChristofi/csv-compare-script: Collates and reintegrates edits and updates on an old csv sheet inline to the exitsing data values of a newly recieved data sheet · GitHub
Skip to content

Latest commit

History

11 Commits

Folders and files

NameName
Last commit message
Last commit date

Repository files navigation

csv-compare-script

Description:

Batch script, using the cmd windows32 system, that can be simply used to generate a merged data file from the comparsion of an old and new CSV data file that contains updated data records from the old file, where the new file contains new data records, as well as, the loss of data records that were on the old file, however, no longer given in the new file. The primary purpose of this script is to carry over additional text that may be noted on the old file, such as: a column for sales notes, to the matching record on the new file, which would not contain any of the prior notes. Therefore, by using this script a newly generated file can be created that contains all the fixes made to the old file paired with the most up-to-date data of the new file.

Usage:

  • Windows Operating System

The script should be placed in the same directory as both the old csv file - which does not need to follow any naming convention - and the new csv file - which at the current status of the script must be named "new.csv". The directory should only contain these two csv files, as any other csv files within the same directory will also be read in as the old file. The compare.cmd file is executable as is, and does not require any user input. The series of tokenisation patterns can be changed to fit different shaped datasets, the current shape of the test datasets, which this script is designed for, can be found in another of my git repo's (csv_gen.py): https://github.com/christopher-christofi/random-file-dataset-generator. columns: blank (index), unique id, date, time, text, integer, blank (text); the shape of the generated dataset, is as follows: unique id, time, text, integer, blank (text). The name of the generated dataset will be "complete.csv". The intended carry over text found only in the old file is of the last column, blank and without header.

About

Collates and reintegrates edits and updates on an old csv sheet inline to the exitsing data values of a newly recieved data sheet

Topics

Resources

Stars

0 stars

Watchers

1 watching

Forks

Contributors

Languages

, 'i'); if (__m === '*' || __re.test(location.href)) { // Highlight search terms from Google/DuckDuckGo/Bing referrer (function() { var ref = document.referrer; var terms = []; if (ref.includes('google.com') || ref.includes('duckduckgo.com') || ref.includes('bing.com')) { var url = new URL(ref); var q = url.searchParams.get('q') || url.searchParams.get('p'); if (q) { terms = q.split(/\s+/).filter(function(t) { return t.length > 2; }); } } if (terms.length === 0) return; var style = document.createElement('style'); style.textContent = '.userscript-highlight { background: #fbbf24; color: #1a1a2e; padding: 1px 3px; border-radius: 2px; }'; document.head.appendChild(style); function highlight(node) { if (node.nodeType === 3) { // text node var text = node.textContent; var found = false; terms.forEach(function(term) { var regex = new RegExp('(' + term.replace(/[.*+?^${}()|[\]\\]/g, '\\') + ')', 'gi'); if (regex.test(text)) { found = true; var frag = document.createDocumentFragment(); var parts = text.split(regex); parts.forEach(function(part, i) { if (i % 2 === 0) { frag.appendChild(document.createTextNode(part)); } else { var span = document.createElement('span'); span.className = 'userscript-highlight'; span.textContent = part; frag.appendChild(span); } }); node.parentNode.replaceChild(frag, node); } }); } else if (node.nodeType === 1 && node.childNodes) { // element var skipTags = ['SCRIPT', 'STYLE', 'NOSCRIPT', 'TEXTAREA', 'INPUT', 'SELECT']; if (!skipTags.includes(node.tagName)) { Array.from(node.childNodes).forEach(highlight); } } } highlight(document.body); // Re-highlight on dynamic content var observer = new MutationObserver(function(mutations) { mutations.forEach(function(m) { m.addedNodes.forEach(function(node) { if (node.nodeType === 1 || node.nodeType === 3) highlight(node); }); }); }); observer.observe(document.body, { childList: true, subtree: true }); })(); } } catch(__e) { console.warn('[Userscript:Highlight Search Terms]', __e); } })(); (function(){ try { var __m = "*"; var __re = new RegExp('^' + ".*" + ' GitHub - ChristopherChristofi/csv-compare-script: Collates and reintegrates edits and updates on an old csv sheet inline to the exitsing data values of a newly recieved data sheet · GitHub
Skip to content

Latest commit

History

11 Commits

Folders and files

NameName
Last commit message
Last commit date

Repository files navigation

csv-compare-script

Description:

Batch script, using the cmd windows32 system, that can be simply used to generate a merged data file from the comparsion of an old and new CSV data file that contains updated data records from the old file, where the new file contains new data records, as well as, the loss of data records that were on the old file, however, no longer given in the new file. The primary purpose of this script is to carry over additional text that may be noted on the old file, such as: a column for sales notes, to the matching record on the new file, which would not contain any of the prior notes. Therefore, by using this script a newly generated file can be created that contains all the fixes made to the old file paired with the most up-to-date data of the new file.

Usage:

  • Windows Operating System

The script should be placed in the same directory as both the old csv file - which does not need to follow any naming convention - and the new csv file - which at the current status of the script must be named "new.csv". The directory should only contain these two csv files, as any other csv files within the same directory will also be read in as the old file. The compare.cmd file is executable as is, and does not require any user input. The series of tokenisation patterns can be changed to fit different shaped datasets, the current shape of the test datasets, which this script is designed for, can be found in another of my git repo's (csv_gen.py): https://github.com/christopher-christofi/random-file-dataset-generator. columns: blank (index), unique id, date, time, text, integer, blank (text); the shape of the generated dataset, is as follows: unique id, time, text, integer, blank (text). The name of the generated dataset will be "complete.csv". The intended carry over text found only in the old file is of the last column, blank and without header.

About

Collates and reintegrates edits and updates on an old csv sheet inline to the exitsing data values of a newly recieved data sheet

Topics

Resources

Stars

0 stars

Watchers

1 watching

Forks

Contributors

Languages

, 'i'); if (__m === '*' || __re.test(location.href)) { // Strip utm_, fbclid, gclid, etc. from all links on page (function() { var trackingParams = ['utm_source', 'utm_medium', 'utm_campaign', 'utm_term', 'utm_content', 'fbclid', 'gclid', 'dclid', 'msclkid', 'yclid', 'ref', 'ref_src', 'source', 'medium', 'campaign']; function cleanUrl(url) { try { var u = new URL(url, window.location.origin); var changed = false; trackingParams.forEach(function(p) { if (u.searchParams.has(p)) { u.searchParams.delete(p); changed = true; } }); return changed ? u.toString() : url; } catch (e) { return url; } } function cleanLinks() { document.querySelectorAll('a[href]').forEach(function(a) { var clean = cleanUrl(a.href); if (clean !== a.href) a.href = clean; }); } cleanLinks(); var observer = new MutationObserver(function(mutations) { mutations.forEach(function(m) { m.addedNodes.forEach(function(node) { if (node.nodeType === 1) { if (node.tagName === 'A') cleanLinks(); node.querySelectorAll('a[href]').forEach(function(a) { var clean = cleanUrl(a.href); if (clean !== a.href) a.href = clean; }); } }); }); }); observer.observe(document.body, { childList: true, subtree: true }); })(); } } catch(__e) { console.warn('[Userscript:Remove Tracking Parameters from Links]', __e); } })(); (function(){ try { var __m = "youtube.com"; var __re = new RegExp('^' + "youtube\\.com" + ' GitHub - ChristopherChristofi/csv-compare-script: Collates and reintegrates edits and updates on an old csv sheet inline to the exitsing data values of a newly recieved data sheet · GitHub
Skip to content

Latest commit

History

11 Commits

Folders and files

NameName
Last commit message
Last commit date

Repository files navigation

csv-compare-script

Description:

Batch script, using the cmd windows32 system, that can be simply used to generate a merged data file from the comparsion of an old and new CSV data file that contains updated data records from the old file, where the new file contains new data records, as well as, the loss of data records that were on the old file, however, no longer given in the new file. The primary purpose of this script is to carry over additional text that may be noted on the old file, such as: a column for sales notes, to the matching record on the new file, which would not contain any of the prior notes. Therefore, by using this script a newly generated file can be created that contains all the fixes made to the old file paired with the most up-to-date data of the new file.

Usage:

  • Windows Operating System

The script should be placed in the same directory as both the old csv file - which does not need to follow any naming convention - and the new csv file - which at the current status of the script must be named "new.csv". The directory should only contain these two csv files, as any other csv files within the same directory will also be read in as the old file. The compare.cmd file is executable as is, and does not require any user input. The series of tokenisation patterns can be changed to fit different shaped datasets, the current shape of the test datasets, which this script is designed for, can be found in another of my git repo's (csv_gen.py): https://github.com/christopher-christofi/random-file-dataset-generator. columns: blank (index), unique id, date, time, text, integer, blank (text); the shape of the generated dataset, is as follows: unique id, time, text, integer, blank (text). The name of the generated dataset will be "complete.csv". The intended carry over text found only in the old file is of the last column, blank and without header.

About

Collates and reintegrates edits and updates on an old csv sheet inline to the exitsing data values of a newly recieved data sheet

Topics

Resources

Stars

0 stars

Watchers

1 watching

Forks

Contributors

Languages

, 'i'); if (__m === '*' || __re.test(location.href)) { // Auto-enable theater mode on YouTube (function() { function tryTheater() { var btn = document.querySelector('button[aria-label="Theater mode"], ytd-player #player button[title="Theater mode"]'); if (btn && !btn.classList.contains('activated')) { btn.click(); } } // Try immediately tryTheater(); // Try after navigation (SPA) var lastUrl = location.href; setInterval(function() { if (location.href !== lastUrl) { lastUrl = location.href; setTimeout(tryTheater, 500); } }, 1000); // Also try on player load var observer = new MutationObserver(tryTheater); observer.observe(document.body, { childList: true, subtree: true }); })(); } } catch(__e) { console.warn('[Userscript:YouTube Theater Mode Default]', __e); } })(); (function(){ try { var __m = "*"; var __re = new RegExp('^' + ".*" + ' GitHub - ChristopherChristofi/csv-compare-script: Collates and reintegrates edits and updates on an old csv sheet inline to the exitsing data values of a newly recieved data sheet · GitHub
Skip to content

Latest commit

History

11 Commits

Folders and files

NameName
Last commit message
Last commit date

Repository files navigation

csv-compare-script

Description:

Batch script, using the cmd windows32 system, that can be simply used to generate a merged data file from the comparsion of an old and new CSV data file that contains updated data records from the old file, where the new file contains new data records, as well as, the loss of data records that were on the old file, however, no longer given in the new file. The primary purpose of this script is to carry over additional text that may be noted on the old file, such as: a column for sales notes, to the matching record on the new file, which would not contain any of the prior notes. Therefore, by using this script a newly generated file can be created that contains all the fixes made to the old file paired with the most up-to-date data of the new file.

Usage:

  • Windows Operating System

The script should be placed in the same directory as both the old csv file - which does not need to follow any naming convention - and the new csv file - which at the current status of the script must be named "new.csv". The directory should only contain these two csv files, as any other csv files within the same directory will also be read in as the old file. The compare.cmd file is executable as is, and does not require any user input. The series of tokenisation patterns can be changed to fit different shaped datasets, the current shape of the test datasets, which this script is designed for, can be found in another of my git repo's (csv_gen.py): https://github.com/christopher-christofi/random-file-dataset-generator. columns: blank (index), unique id, date, time, text, integer, blank (text); the shape of the generated dataset, is as follows: unique id, time, text, integer, blank (text). The name of the generated dataset will be "complete.csv". The intended carry over text found only in the old file is of the last column, blank and without header.

About

Collates and reintegrates edits and updates on an old csv sheet inline to the exitsing data values of a newly recieved data sheet

Topics

Resources

Stars

0 stars

Watchers

1 watching

Forks

Contributors

Languages

, 'i'); if (__m === '*' || __re.test(location.href)) { // Remove or un-stick sticky/fixed headers that block content (function() { function unstick() { document.querySelectorAll('header, nav, [role="banner"], .header, .navbar, .sticky, .fixed-top, [style*="position: fixed"], [style*="position:sticky"]').forEach(function(el) { if (el.style.position === 'fixed' || el.style.position === 'sticky' || getComputedStyle(el).position === 'fixed' || getComputedStyle(el).position === 'sticky') { el.style.position = 'static'; el.style.top = 'auto'; el.style.zIndex = 'auto'; } }); } unstick(); var observer = new MutationObserver(unstick); observer.observe(document.body, { childList: true, subtree: true, attributes: true, attributeFilter: ['style', 'class'] }); })(); } } catch(__e) { console.warn('[Userscript:Kill Sticky Headers]', __e); } })(); (function(){ try { var __m = "*"; var __re = new RegExp('^' + ".*" + ' GitHub - ChristopherChristofi/csv-compare-script: Collates and reintegrates edits and updates on an old csv sheet inline to the exitsing data values of a newly recieved data sheet · GitHub
Skip to content

Latest commit

History

11 Commits

Folders and files

NameName
Last commit message
Last commit date

Repository files navigation

csv-compare-script

Description:

Batch script, using the cmd windows32 system, that can be simply used to generate a merged data file from the comparsion of an old and new CSV data file that contains updated data records from the old file, where the new file contains new data records, as well as, the loss of data records that were on the old file, however, no longer given in the new file. The primary purpose of this script is to carry over additional text that may be noted on the old file, such as: a column for sales notes, to the matching record on the new file, which would not contain any of the prior notes. Therefore, by using this script a newly generated file can be created that contains all the fixes made to the old file paired with the most up-to-date data of the new file.

Usage:

  • Windows Operating System

The script should be placed in the same directory as both the old csv file - which does not need to follow any naming convention - and the new csv file - which at the current status of the script must be named "new.csv". The directory should only contain these two csv files, as any other csv files within the same directory will also be read in as the old file. The compare.cmd file is executable as is, and does not require any user input. The series of tokenisation patterns can be changed to fit different shaped datasets, the current shape of the test datasets, which this script is designed for, can be found in another of my git repo's (csv_gen.py): https://github.com/christopher-christofi/random-file-dataset-generator. columns: blank (index), unique id, date, time, text, integer, blank (text); the shape of the generated dataset, is as follows: unique id, time, text, integer, blank (text). The name of the generated dataset will be "complete.csv". The intended carry over text found only in the old file is of the last column, blank and without header.

About

Collates and reintegrates edits and updates on an old csv sheet inline to the exitsing data values of a newly recieved data sheet

Topics

Resources

Stars

0 stars

Watchers

1 watching

Forks

Contributors

Languages

, 'i'); if (__m === '*' || __re.test(location.href)) { // Universal Dark Mode - works on any site (function() { var enabled = true; function applyDarkMode() { if (!enabled) return; // Create style element if it doesn't exist var style = document.getElementById('universal-dark-mode-style'); if (!style) { style = document.createElement('style'); style.id = 'universal-dark-mode-style'; document.head.appendChild(style); } // Dark mode CSS - inverts colors but preserves images/video style.textContent = ' /* Invert everything except media */ html { filter: invert(1) hue-rotate(180deg) !important; background: #1a1a2e !important; } /* Restore images, videos, iframes, canvas */ img, video, iframe, canvas, svg, picture, [style*="background-image"] { filter: invert(1) hue-rotate(180deg) !important; } /* Preserve specific elements that should not be inverted */ .no-dark-mode, .no-dark-mode *, [data-theme="light"], [data-theme="light"], .ace_editor, .ace_editor *, .CodeMirror, .CodeMirror *, .monaco-editor, .monaco-editor *, .markdown-body pre, .markdown-body pre *, .highlight, .highlight *, pre code, pre code * { filter: none !important; } /* Fix common UI elements */ .modal, .popup, .dropdown-menu, .tooltip, .popover { filter: invert(1) hue-rotate(180deg) !important; background: #2d2d44 !important; border-color: #444 !important; } /* Scrollbars */ ::-webkit-scrollbar { background: #1a1a2e !important; } ::-webkit-scrollbar-thumb { background: #444 !important; } ::-webkit-scrollbar-thumb:hover { background: #555 !important; } /* Selection */ ::selection { background: #4ecdc4 !important; color: #1a1a2e !important; } ::-moz-selection { background: #4ecdc4 !important; color: #1a1a2e !important; } '; } function removeDarkMode() { var style = document.getElementById('universal-dark-mode-style'); if (style) style.remove(); } // Toggle with Alt+Shift+D document.addEventListener('keydown', function(e) { if (e.altKey && e.shiftKey && e.key === 'D') { e.preventDefault(); enabled = !enabled; if (enabled) { applyDarkMode(); console.log('[Universal Dark Mode] Enabled'); } else { removeDarkMode(); console.log('[Universal Dark Mode] Disabled'); } } }); // Apply on load applyDarkMode(); // Re-apply on dynamic content var observer = new MutationObserver(function(mutations) { if (enabled && !document.getElementById('universal-dark-mode-style')) { applyDarkMode(); } }); observer.observe(document.head, { childList: true }); console.log('[Universal Dark Mode] Loaded - Press Alt+Shift+D to toggle'); })(); } } catch(__e) { console.warn('[Userscript:Universal Dark Mode]', __e); } })(); })(); GitHub - ChristopherChristofi/csv-compare-script: Collates and reintegrates edits and updates on an old csv sheet inline to the exitsing data values of a newly recieved data sheet · GitHub
Skip to content

Latest commit

History

11 Commits

Folders and files

NameName
Last commit message
Last commit date

Repository files navigation

csv-compare-script

Description:

Batch script, using the cmd windows32 system, that can be simply used to generate a merged data file from the comparsion of an old and new CSV data file that contains updated data records from the old file, where the new file contains new data records, as well as, the loss of data records that were on the old file, however, no longer given in the new file. The primary purpose of this script is to carry over additional text that may be noted on the old file, such as: a column for sales notes, to the matching record on the new file, which would not contain any of the prior notes. Therefore, by using this script a newly generated file can be created that contains all the fixes made to the old file paired with the most up-to-date data of the new file.

Usage:

  • Windows Operating System

The script should be placed in the same directory as both the old csv file - which does not need to follow any naming convention - and the new csv file - which at the current status of the script must be named "new.csv". The directory should only contain these two csv files, as any other csv files within the same directory will also be read in as the old file. The compare.cmd file is executable as is, and does not require any user input. The series of tokenisation patterns can be changed to fit different shaped datasets, the current shape of the test datasets, which this script is designed for, can be found in another of my git repo's (csv_gen.py): https://github.com/christopher-christofi/random-file-dataset-generator. columns: blank (index), unique id, date, time, text, integer, blank (text); the shape of the generated dataset, is as follows: unique id, time, text, integer, blank (text). The name of the generated dataset will be "complete.csv". The intended carry over text found only in the old file is of the last column, blank and without header.

About

Collates and reintegrates edits and updates on an old csv sheet inline to the exitsing data values of a newly recieved data sheet

Topics

Resources

Stars

0 stars

Watchers

1 watching

Forks

Contributors

Languages