Visual Studio Code CheatSheet

This cheat sheet was a lifesaver for me; I hope it extends a helping hand to others too.

BASICS
Ctrl+Shift+N	New window/instance
Ctrl+Shift+W	Close window/instance
Ctrl+Shift+P or F1	Show Command Palette
Ctrl+P	Quick Open, Go to File
Ctrl+,	User Settings
Ctrl+K Ctrl+S	Keyboard Shortcuts
Ctrl+C	Copy line (empty selection)
Ctrl+X	Cut line (empty selection)
Alt+ ↑ / ↓	Move line up/down
Shift+Alt + ↓ / ↑	Copy line up/down
Ctrl+Shift+K	Delete line
Ctrl+Shift+Enter	Insert line above
Ctrl+Home	Go to beginning of file
Ctrl+End	Go to end of file
Home / End	Go to beginning/end of line
Ctrl+↑ / ↓	Scroll line up/down
Ctrl+Shift+\	Jump to matching bracket
Ctrl+Enter	Insert line below Basic editing
Ctrl+] / [	Indent/outdent line
Ctrl+Shift+[	Fold (collapse) region
Ctrl+Shift+]	Unfold (uncollapse) region
Alt+PgUp / PgDn	Scroll page up/down Basic editing
Ctrl+/	Toggle line comment
Alt+Z	Toggle word wrap
Ctrl+K Ctrl+U	Remove line comment Navigation
Ctrl+T	Show all Symbols
Ctrl+P	Go to File...
Ctrl+K Ctrl+[	Fold (collapse) all subregions
Ctrl+K Ctrl+0	Fold (collapse) all regions
Ctrl+K Ctrl+J	Unfold (uncollapse) all regions
Ctrl+K Ctrl+]	Unfold (uncollapse) all subregions
Ctrl+K Ctrl+C	Add line comment
Ctrl+Shift+O	Go to Symbol
Ctrl+G	Go to Line Navigation
Ctrl+Shift+M	Show Problems panel
Shift+F8	Go to previous error or warning
Ctrl+Shift+Tab	Navigate editor group history
F8	Go to next error or warning
EDITOR
Ctrl+K Ctrl+ ←/→	Focus into previous/next editor group
Ctrl+K ← / →	Move active editor group
Ctrl+F4, Ctrl+W	Close editor
Ctrl+\	Split editor
Ctrl+ 1 / 2 / 3	Focus into 1st, 2nd or 3rd editor group
Ctrl+K F	Close folder
Ctrl+Shift+PgUp / PgDn	Move editor left/right
Ctrl+M	Toggle Tab moves
Shift+Alt+A	Toggle block comment
Ctrl+N	New File
Ctrl+S	Save
Ctrl+Shift+S	Save As
Ctrl+O	Open File
Ctrl+K S	Save All
Ctrl+K Ctrl+W	Close All
Ctrl+Shift+T	Reopen closed editor
Ctrl+F4	Close
Ctrl+K	Enter Keep preview mode editor open
Ctrl+Shift+Tab	Open previous
Ctrl+K P	Copy path of active file
Ctrl+Tab	Open next
Ctrl+K R	Reveal active file in Explorer
Ctrl+K O	Show active file in new window/instance
F11	Toggle full screen
Ctrl+Shift+E	Show Explorer / Toggle focus
Ctrl+Shift+G	Show Source Control
Ctrl+Shift+D	Show Debug
Ctrl+Shift+F	Show Search Display
Ctrl+Shift+X	Show Extensions
Ctrl+Shift+J	Toggle Search details
Ctrl+Shift+U	Show Output panel
Ctrl+Shift+H	Replace in files
Ctrl+Shift+V	Open Markdown preview
Shift+Alt+0	Toggle editor layout (horizontal/vertical)
Ctrl+K Z	Zen Mode (Esc, Esc to exit)
Ctrl+K V	Open Markdown preview to the side
F5	Start/Continue Debug
F9	Toggle breakpoint
F10	Step over
Shift+F5	Stop
F11 / Shift+F11	Step into/out
Ctrl+K Ctrl+I	Show hover Integrated terminal
Ctrl+`	Show integrated terminal
Ctrl+C	Copy selection
Ctrl+V	Paste into active terminal
Ctrl+Shift+`	Create new terminal Integrated terminal
Ctrl+↑ / ↓	Scroll up/down
Ctrl+Home /	End Scroll to top/bottom
Shift+PgUp / PgDn	Scroll page up/down
SEARCH AND REPLACE
Ctrl+F	Find
F3 / Shift+F3	Find next/previous
Alt+Enter	Select all occurences of Find match
Ctrl+H	Replace Search and replace
Ctrl+D	Add selection to next find match
Alt+C / R / W	Toggle case-sensitive / regex / whole word
Ctrl+K Ctrl+D	Move last selection to next find match
MULTI CURSOR SELECTION
Alt+Click	Insert cursor
Ctrl+U	Undo last cursor operation
Shift+Alt+I	Insert cursor at end of each line selected
Ctrl+Alt+ ↑ / ↓	Insert cursor above / below
Ctrl+L	Select current line
Ctrl+F2	Select all occurrences of current word
Shift+Alt+ →	Expand selection
Ctrl+Shift+L	Select all occurrences of current selection
Shift+Alt+ ←	Shrink selection
Ctrl+Shift+Alt + (arrow key)	Column (box) selection
Ctrl+Shift+Alt + PgUp/PgDn	Column (box) selection page up/down
Shift+Alt + (drag mouse)	Column (box) selection
LANGUAGE EDITING
F2	Rename
F12	Go to Definition
Ctrl+K F12	Open Definition to the side
Ctrl+.	Quick Fix
Alt+F12	Peek Definition
Ctrl+Space, Ctrl+I	Trigger suggestion
Shift+Alt+F	Format document
Ctrl+K Ctrl+F	Format selection
Ctrl+Shift+Space	Trigger parameter hints
Shift+F12	Show References
Ctrl+K Ctrl+X	Trim trailing whitespace
Ctrl+K M	Change file language

Note: Knowledge gathered is sourced from the social platform, and credit is rightfully attributed to the diverse individuals generously sharing their wisdom.

Extract data from HTML table in an array using jQuery.

Individuals encounter challenges working with data in HTML when attempting to integrate it into their code. The following presents a straightforward method for extracting data from an HTML table and storing it in an array.

  // following lines will return header text in array from thead section let tableHeaderValues = $("#mytable thead th").map(function() { return this.innerText; }).get() console.log(tableHeaderValues); // following lines will return in tbody, as an array object let tableBodyValues = $("#mytable tbody tr").map(function() { return [$("td",this).map(function() { return this.innerText; }).get()]; }).get(); console.log(tableBodyValues);

SharePoint Useful URLs for administrators and super users

This post serves as a valuable reference hub for all the handy shortcut URLs in SharePoint, streamlining tasks for administrators and super users.

While others have shared these URLs in various blog posts, I aim to safeguard them within my own blog, ensuring their accessibility for future generations!

Frequently used

Title	URL
Remove nav bar, header & command bar	?env=WebView (after .aspx)
Remove nav bar & header	?env=Embedded
Open list/ library in Microsoft Lists	?env=WebViewList
Site contents	/_layouts/15/viewlsts.aspx /_layouts/15/viewlsts.aspx?view=14 (old style view)
Manage content & structure	/_layouts/sitemanager.aspx
Audit log reports	/_layouts/Reporting.aspx?Category=Auditing
Shared with us	/Shared%20Documents/Forms/AllItems.aspx?view=3

Users and permissions

Title	URL
People	/_layouts/people.aspx
Groups	/_layouts/groups.aspx
Site Collection Admins	/_layouts/mngsiteadmin.aspx
Advanced Permissions	/_layouts/user.aspx

Galleries

Title	URL
Site Columns	/_layouts/mngfield.aspx
Site content types	/_layouts/mngctype.aspx
Web parts	/_catalogs/wp/Forms/AllItems.aspx
List templates	/_catalogs/lt/Forms/AllItems.aspx
Master Pages	/_layouts/ChangeSiteMasterPage.aspx
Themes	/_catalogs/theme/Forms/AllItems.aspx
Solutions	/_catalogs/solutions/Forms/AllItems.aspx

Site administration

Title	URL
Regional settings	/_layouts/regionalsetng.aspx
Content and structure	/_Layouts/sitemanager.aspx?Source={WebUrl}_layouts/settings.aspx
Content and structure logs	/_Layouts/SiteManager.aspx?lro=all
Site libraries and lists	/_layouts/mcontent.aspx
User alerts	/_layouts/sitesubs.aspx
RSS	/_layouts/siterss.aspx
Search and offline availability	/_layouts/srchvis.aspx
Sites and workspaces	/_layouts/mngsubwebs.aspx
Workflows	/_layouts/wrkmng.aspx
Workflow settings	/_layouts/wrksetng.aspx
Related Links scope settings	/_layouts/RelLinksScopeSettings.aspx
Content Organizer Settings	/_layouts/DocumentRouterSettings.aspx?Source=settings.aspx
Content Organizer Rules	/RoutingRules/Group%20by%20Content%20Type.aspx
Site output cache	/_Layouts/areacachesettings.aspx
Term store management	/_Layouts/termstoremanager.aspx
Taxonomy Hidden List	/Lists/TaxonomyHiddenList
Searchable columns	/_Layouts/NoCrawlSettings.aspx

Look and feel

Title	URL
Welcome page	/_Layouts/AreaWelcomePage.aspx
Title, description and icon	/_layouts/prjsetng.aspx
Master page	/_Layouts/ChangeSiteMasterPage.aspx
Page layouts and site templates	/_Layouts/ChangeSiteMasterPage.aspx
Tree view	/_layouts/navoptions.aspx
Site theme	/_layouts/themeweb.aspx
Navigation	/_layouts/AreaNavigationSettings.aspx

Site actions

Title	URL
Manage site features	/_layouts/ManageFeatures.aspx
Reset to site definition	/_layouts/reghost.aspx
Delete this site	/_layouts/deleteweb.aspx
Site web analytics reports	/_layouts/WebAnalytics/Report.aspx?t=SummaryReport&l=s
Site collection web analytics reports	/_layouts/WebAnalytics/Report.aspx?t=SummaryReport&l=sc

Site collection administration

Title	URL
Search settings	/_layouts/enhancedSearch.aspx
Search scopes	/_layouts/viewscopes.aspx
Search keywords	/_layouts/listkeywords.aspx
Site level recycle bin	/_layouts/RecycleBin.aspx
Site collection recycle bin	/_layouts/AdminRecycleBin.aspx
Site collection features	/_layouts/ManageFeatures.aspx?Scope=Site
Site directory settings	/_layouts/SiteDirectorySettings.aspx
Site hierarchy	/_layouts/vsubwebs.aspx
Site collection navigation	/_layouts/SiteNavigationSettings.aspx
Site collection audit settings	/_layouts/AuditSettings.aspx
Audit log reports	/_layouts/Reporting.aspx?Category=Auditing
Portal site connection	/_layouts/portal.aspx
Site collection policies	/_layouts/Policylist.aspx
Storage Metrics	/_layouts/storman.aspx
Record declaration settings	/_layouts/InPlaceRecordsSettings.aspx?Source=settings.aspx
Content type publishing	/_Layouts/contenttypesyndicationhubs.aspx
Site collection cache profiles	/_Layouts/RedirectPage.aspx?Target={SiteCollectionUrl}cache profiles
Site collection object cache	/_Layouts/objectcachesettings.aspx
Content type service application error log	/Lists/ContentTypeAppLog
Site collection output cache	/_Layouts/sitecachesettings.aspx
Variations	/_Layouts/VariationSettings.aspx
Variation labels	/_Layouts/VariationLabels.aspx
Translatable columns	/_Layouts/TranslatableSettings.aspx
Variation logs	/_Layouts/VariationLogs.aspx
Suggested Content Browser Locations	/PublishedLinks/
Document ID settings	/_Layouts/DocIdSettings.aspx
SharePoint Designer Settings	/_layouts/SharePointDesignerSettings.aspx
Visual Upgrade	/_layouts/suppux.aspx
Help settings	/_layouts/HelpSettings.aspx

Central administration

Title	URL
Manage web applications	/_admin/WebApplicationList.aspx
Create site collections	/_admin/createsite.aspx
Manage service applications	/_admin/ServiceApplications.aspx
Manage content databases	/_admin/CNTDBADM.aspx
Check job status	/_admin/Timer.aspx
Manage farm administrators group	/_layouts/people.aspx?MembershipGroupId=3
Configure service accounts	/_admin/FarmCredentialManagement.aspx
Configure send to connections	/_admin/OfficialFileAdmin.aspx
Configure content deployment paths and jobs	/_admin/Deployment.aspx
Manage form templates	_admin/ManageFormTemplates.aspx
Manage servers in farm	/_admin/FarmServers.aspx
Manage services on server	/_admin/Server.aspx
Manage farm features	/_admin/ManageFarmFeatures.aspx
Configure alternate access mappings	/_admin/AlternateUrlCollections.aspx
Perform a backup	/_admin/Backup.aspx
Restore from backup	/_admin/BackupHistory.aspx?restore=1&filter=1
Perform site collection backup	/_admin/SiteCollectionBackup.aspx
Convert farm license type	/_admin/Conversion.aspx
Check product and patch installation status	/_admin/PatchStatus.aspx
Check upgrade status	/_admin/UpgradeStatus.aspx

Common actions

Title	URL
Create new	_layouts/spscreate.aspx _layouts/create.aspx
View lists	_layouts/viewlsts.aspx
Create site groups	_layouts/permsetup.aspx
Quick launch	_layouts/quiklnch.aspx
Workflow history list	/lists/Workflow History
SharePoint server version + patch level	/_vti_pvt/Service.cnf (run at site collection level)
Web part maintenance mode	?Contents=1 (classic) ?maintenancemode=true (modern)
Save as site template	_layouts/savetmpl.aspx
Manage user alerts	_layouts/AlertsAdmin.aspx

REST API examples

Operation	SharePoint REST API endpoint
Site
Get a SharePoint Site Collection	[domain]/_api/site
Get a specific site or web	[domain]/_api/web
Get a sites title	[domain]/_api/title
List
Get all lists from a site	[domain]/_api/web/lists
Get all items from a list	[domain]/_api/web/lists/getbytitle(listname)/items
Get a lists title	[domain]/_api/web/lists/getbytitle(listname)?select=Title
Get all columns within a list	[domain]/_api/web/lists/getbytitle(listname)/Fields
Get list from GUID	[domain]/_api/Web/Lists(list GUID here)
Get list item by ID	[domain]/_api/Web/Lists/GetByTitle/(listtitle)/GetItemById(2)
Get selected fields for list items	[domain]/_api/Web/Lists/GetByTitle/(listtitle)/Items?select=ID,Title
User
Get current user information	[domain]/_api/web/currentUser
Get all site users	[domain]/_api/Web/siteusers
Group
Get all groups from the site	[domain]/_api/Web/siteusers/sitegroups
Get group by group ID	[domain]/_api/Web/sitegroups/GetById(GroupId)
Get all users from group	[domain]/_api/Web/sitegroups(Id)/users

Extract all URLs from a web page

Here is a quick JavaScript snippet to extract all URLs from a webpage, using Developer Tools. No Browser Extension is required!

const results = []; var urls = document.getElementsByTagName('a'); for (urlIndex in urls) { const url = urls[urlIndex] const externalLink = url.host !== window.location.host if(url.href && url.href.indexOf('://')!==-1) results.push([url.href]) // url.rel } const urlLists = results.map((line)=>{ return line.map((cell)=>{ if(typeof(cell)==='boolean') return cell ? 'TRUE': 'FALSE' if(!cell) return '' let value = cell.replace(/[\f\n\v]*\n\s*/g, "\n").replace(/[\t\f ]+/g, ' '); value = value.replace(/\t/g, ' ').trim(); return `"${value}"` }).join('\t') }).join("\n"); console.log(urlLists)// display url list copy(urlLists) // copy to clipboard

Get icon from image file - CSS

CSS to get Carret symbol

.carret{ display: inline-block; width: 0; height: 0; border-top: 10px solid; border-top: 4px solid \9; border-right: 10px solid transparent; border-left: 10px solid transparent; }

---

Use Image icon file, and get the required image by background-position

First icon from the image

Icon from the middle of image

.get-allicons{ background-image: url('https://www.bypeople.com/wp-content/uploads/2020/03/free-svg-icons-ui-development-1.png'); background-repeat: no-repeat; display: inline-block; vertical-align: sub; width: 45px; height: 45px; position: relative; top: 1px; vertical-align: middle; } .iconoff1{ background-position: -10px -10px; } .iconoff2{ background-position: -319px -1348px; }

Clone columns of the table using jQuery

Following is the example where you can clone required columns and sequence from the source table to the new table

table columns like (source table) sr.no | name | address | city | DOB clone to another table with (target table) sr.no | name cloneTable("#source","#target",[0,1]) or clone to another table with (target table) sr.no | name | city cloneTable("#source","#target",[0,3,1]); function cloneTable(source,target,cols) { target = $(target); $(`${source} tr`).each(function() { let tds = $(this).children(), row = $("<tr></tr>"); for(let c of cols) row.append(tds.eq(c).clone()); row.appendTo(target); }); }//cloneTable

Read File Content from SharePoint List Items

Working function, where you can read file content available as an attachment in your SharePoint list item.
#sharepoint #jquery #sharepointsolutions

     <div> <h1>Read File</h1> <div> <input type="file" id="file_input"> </div> <div> <div id="readfiletextarea" rows="5" style="width:400px;"></div> <a href="#" onclick="loadURLToInputFiled('https://domain.sharepoint.com/sites/Lists/myList/Attachments/1/myFile.csv')">Click to Load File</a> <br /> <a href="#" onclick="readfiledata()">Click to Read File</a> <br /> /*Read attachment data and display*/ function readfiledata(){ let input = document.getElementById('file_input') let textarea = document.getElementById('readfiletextarea') let files = input.files; if (files.length == 0) return; const file = files[0]; let reader = new FileReader(); reader.onload = (e) => { const file = e.target.result; const lines = file.split(/\r\n|\n/); textarea.value = lines.join('\n'); }; reader.onerror = (e) => alert(e.target.error.name); reader.readAsText(file); } /*Load URL to input type file */ function loadURLToInputFiled(url){ getURL(url, (fileBlob)=>{ // Load img blob to input // WIP: UTF8 character error let fileName = 'tmpfile.txt' let file = new File([fileBlob], fileName,{type:"text/txt", lastModified:new Date().getTime()}, 'utf-8'); let container = new DataTransfer(); container.items.add(file); document.querySelector('#file_input').files = container.files; }) } // xmlHTTP return blob respond function getURL(url, callback){ var xhr = new XMLHttpRequest(); xhr.onload = function() { callback(xhr.response); }; xhr.open('GET', url); xhr.responseType = 'blob'; xhr.send(); }