This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # 📌 Formats parcel IDs into spaced DeKalb County format (e.g. 1508504015 → 15 085 04 015) | |
| =IF(A2="","",REGEXREPLACE(REGEXREPLACE(TO_TEXT(A2),"\D",""),"(\d{2})(\d{3})(\d{2})(\d{3})","$1 $2 $3 $4")) |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Goal | CSS 3 | XPath | |
|---|---|---|---|
| All Elements | * | //* | |
| All P Elements | p | //p | |
| All Child Elements | p>* | //p/* | |
| Element By ID | #foo | //*[@id=’foo’] | |
| Element By Class | .foo | //*[contains(@class,’foo’)] | |
| Element With Attribute | *[title] | //*[@title] | |
| First Child of All P | p>*:first-child | //p/*[0] | |
| All P with an A child | Not possible | //p[a] | |
| Next Element | p + * | //p/following-sibling::*[0] |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| add "--cli-binary-format raw-in-base64-out" with your command | |
| i.e | |
| aws lambda invoke --function-name foo_bar --payload file://payload.json --cli-binary-format raw-in-base64-out response.txt |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| drop program sshakir_find_fin go | |
| create program sshakir_find_fin | |
| prompt | |
| "Output to File/Printer/MINE" = "MINE" | |
| , "Person Id:" = 0 | |
| , "Encounter Id:" = 0 | |
| with OUTDEV, PERSONID, ENCNTRID | |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| for (var key in p) { | |
| if (p.hasOwnProperty(key)) { | |
| console.log(key + " -> " + p[key]); | |
| } | |
| } |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| module.exports = (dataToConvert) => { | |
| let data = {} | |
| dataToConvert.forEach((val, index) => { | |
| data[Object.keys(dataToConvert[index])] = Object.values(dataToConvert[index])[0] | |
| }) | |
| return data; | |
| } |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ' If you want to be sure that the static content has refreshed properly - take out the "/manager" part of the URL from the content management page, and replace it with:' | |
| /custom_mpage_content/custom-components/js/custom-components.js | |
| ' That should let you download the JS file from the web server, rather than the code warehouse, so you can make sure that it has actually refreshed. | |
| You can also refresh the static content by running the CCL program manually: ' | |
| mp_refresh_static_content "MINE", "custom_mpage_content" |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| select * | |
| from dm_info d | |
| where d.info_domain = "INS" | |
| and d.info_name = "CONTENT_SERVICE_URL" | |
| with time = 10 |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # run from within directory tha contains CSV files you want to combine | |
| cat *.csv > combined.csv |
NewerOlder

