Skip to content

Instantly share code, notes, and snippets.

@mpecka
mpecka / parseQueryParameters.js
Last active October 16, 2022 11:38
Parse location.search query parameters (convert to object)
function getQueryParams(url) {
const paramArr = url.slice(url.indexOf('?') + 1).split('&');
const params = {};
paramArr.map(param => {
const [key, val] = param.split('=');
params[key] = decodeURIComponent(val);
})
return params;
}
@mpecka
mpecka / truncateString.js
Created September 20, 2022 10:51
JS Truncate String Function
function truncateString(str, len, suffix) {
var suffix = suffix || "...";
var len = len || 10;
if (str.length <= len) {
return str;
} else {
return str.slice(0, len - suffix.length) + suffix;
}
}
@mpecka
mpecka / CRMdata.xml
Created December 11, 2018 08:59
CRM Data Example
<?xml version="1.0" encoding="utf-8"?>
<leads>
<lead>
<leadId>123</leadId>
<itemId>100321</itemId>
<clientId>c102030</clientId>
<status>NUR</status>
</lead>
<lead>
<leadId>124</leadId>
@mpecka
mpecka / ExcelRemoveAccents.vb
Last active April 22, 2024 16:40
Excel Remove Accents
Function StripAccent(thestring As String)
Dim A As String * 1
Dim B As String * 1
Dim i As Integer
Const AccChars= "áäčďéěíĺľňóôőöŕšťúůűüýřžÁÄČĎÉĚÍĹĽŇÓÔŐÖŔŠŤÚŮŰÜÝŘŽ"
Const RegChars= "aacdeeillnoooorstuuuuyrzAACDEEILLNOOOORSTUUUUYRZ"
For i = 1 To Len(AccChars)
A = Mid(AccChars, i, 1)
B = Mid(RegChars, i, 1)
thestring = Replace(thestring, A, B)