What?
This is a simple article to demonstrate how to type special characters not found on your keyboard or on a Qwerty UK/US keyboard layout.

Why?
Being able to type international characters from other alphabets is necessary when dealing with languages other than English. Preserving files in unicode or utf-8 encoding will help but there will be times when you have lost the formatting and get weird question mark characters instead such as: .

How?
Ensure you are using the numbers on your numeric keypad and NOT the numbers at the top of your keyboard for the following steps. Also check that you have "Num Lock" on/enabled. Typing a special character is 3 easy steps:

  1. Hold down the ALT key (preferably the one on the left of the spacebar and not the Alt Gr often found on the right of the spacebar)
  2. then press the numbers in the numeric pad (while still holding down the ALT key),
  3. then let go of the ALT key.
Remember: This will not work with the numbers at the top of your keyboard unless you are on a laptop and can apply a function lock (fn) and the numbers on the right of your keyboard are enabled.


Applies To:
  • Microsoft Windows 10 Pro v10.0.18362
What?
This is a list of apps that if run via the run command, or used in a desktop shortcut, or that you want to include in automation software such as AutoHotkey, opens any specific Windows OS settings page. This does not make the change to the setting itself, just displays it to the user for them to make the choice.

Why?
I needed a command that can be run from the command-line in an AutoHotkey app to open the notifications page of the Windows 10 Settings panel to allow users to enable/disable notifications. Why write this article when there's a perfectly ok post on the Microsoft website? Well I could bookmark that page or save myself a click...

How?
To test any of the following, type the windows key and select "Run..." ( + R). Then type the value in the 2nd column "App to Run" then OK to run it:

What?
This is a quick reminder for myself on opening a CSV in MS Excel but without converting long numbers into exponential notations (which are incorrectly rounded anyway).

My Data:
copyraw
Account ID,Name,Phone,Record ID
1457102000000135533,Joel,00441234567890,1457102000000165989
1457102000000135566,Stanley,01709123456,1457102000000167543
1457102000000135608,David,00331234567890,1457102000000166795
  1.  Account ID,Name,Phone,Record ID 
  2.  1457102000000135533,Joel,00441234567890,1457102000000165989 
  3.  1457102000000135566,Stanley,01709123456,1457102000000167543 
  4.  1457102000000135608,David,00331234567890,1457102000000166795 
My Excel:
copyraw
Account ID	Name	Phone	Record ID
1.4571E+18	Joel	4.41235E+11	1.4571E+18
1.4571E+18	Stanley	1709123456	1.4571E+18
1.4571E+18	David	3.31235E+11	1.4571E+18
  1.  Account ID    Name    Phone    Record ID 
  2.  1.4571E+18    Joel    4.41235E+11    1.4571E+18 
  3.  1.4571E+18    Stanley    1709123456    1.4571E+18 
  4.  1.4571E+18    David    3.31235E+11    1.4571E+18 

How?
Firstly, save the CSV file as text file (*.TXT).
Category: Excel :: Article: 689

What?
This is an article to remind me how to search a column in an Excel file for values found in another column (in this example, on another worksheet in the same workbook).

How?
So for demonstration purposes, I'm using a new Excel file with two worksheets called "Sheet1" and "Sheet2" respectively.

What?
This article serves to explain how to split a spreadsheet consisting of multiple sheets into separate files per sheet.

Why?
The Excel file in question was about 36000 rows and had a file size of about 11Mb. In order for an import process to work, the import would only accept XLS files no greater than 1Mb. So our script has to split a single spreadsheet into multiple worksheets of 3000 rows each, and then output each sheet to a separate file that is formatted as XLS (Not *.xlsx).

How?
In summary, we are going to move the Excel file to a folder of its own. We're going to run two VBScripts in two stages, firstly to split the specified rows into sheets, then each sheet into a file each. And we want all the files generated to be created in the same folder.

Applies to:
  • Windows Live Mail 2012
What?
A quick article on how to update the Microsoft Live Server URL for Hotmail using Windows Live Mail. Well how to deactivate an account and set up a new one in Windows Live Mail. If you used IMAP all along then the new account will have all your mail.

The error
copyraw
Unable to send or receive messages for the Hotmail (someone) account.

Subject 'your Microsoft Issue'
Server Error: 3219
Windows Live Mail Error ID: 0x8DE00005
Unable to send or receive messages for the Hotmail (someone) account.

Server Error: 3219
Server: 'https://mail.services.live.com/DeltaSync_v2.0.0/Sync.aspx'
Windows Live Mail Error ID: 0x8DE00005
  1.  Unable to send or receive messages for the Hotmail (someone) account. 
  2.   
  3.  Subject 'your Microsoft Issue' 
  4.  Server Error: 3219 
  5.  Windows Live Mail Error ID: 0x8DE00005 
  6.  Unable to send or receive messages for the Hotmail (someone) account. 
  7.   
  8.  Server Error: 3219 
  9.  Server: 'https://mail.services.live.com/DeltaSync_v2.0.0/Sync.aspx' 
  10.  Windows Live Mail Error ID: 0x8DE00005 

How?
I don't remember the time when the Microsoft website became helpful but as they already have an article on this, I'm going to do a bunch of screenshots:
Category: Windows OS :: Article: 643

What I have:
A CSV file exported from Excel along with double-quotes
copyraw
label1,label2
item1a,item2a
item1c,"item2c,c"
item1b,item2b
  1.  label1,label2 
  2.  item1a,item2a 
  3.  item1c,"item2c,c" 
  4.  item1b,item2b 

What I want:
To read the file (stored on the server) and convert to a JavaScript array of objects
copyraw
var my_object_array = [
     { my_col1_val: 'item1a', my_col2_val: 'item2a' },
     { my_col1_val: 'item1b', my_col2_val: 'item2b' },
     { my_col1_val: 'item1c', my_col2_val: 'item2c,c' }
];
  1.  var my_object_array = [ 
  2.       { my_col1_val: 'item1a', my_col2_val: 'item2a' }, 
  3.       { my_col1_val: 'item1b', my_col2_val: 'item2b' }, 
  4.       { my_col1_val: 'item1c', my_col2_val: 'item2c,c' } 
  5.  ]
What I want again:
  • Read a CSV file already uploaded with JavaScript
  • Populate a JS array with each row
  • Account for strings containing double-quotes (and commas to ignore)
  • Sort the resulting object array

How?
Category: Excel :: Article: 635

What?
A quick article with the code to retrieve your product key in Windows 7 with a small VB script file. There are other articles on the web about this but the ones I found returned errors such as WshShell not valid. This article has a working example applicable to Windows 7 Professional.

Why?
With the Windows 10 operating system offered as a free upgrade (for Windows 7 or later at time of print), I needed the serial number / product key from my Windows 7 Professional 32-bit operating system. I didn't want to dig through my CD/DVDs to find my original windows 7 disc and no longer have access to the email account when I purchased Windows 7 (my university one).

How?
I'm going to use my trusty notepad program, copy the following code to it, and run it:

Credit where Credit is Due:


Feel free to copy, redistribute and share this information. All that we ask is that you attribute credit and possibly even a link back to this website as it really helps in our search engine rankings.

Disclaimer: The information on this website is provided without warranty and any content is merely the opinion of the author. Please try to test in development environments prior to adapting them to your production environments. The articles are written in good faith and, at the time of print, are working examples used in a commercial setting.

Thank you for visiting and, as always, we hope this website was of some use to you!

Kind Regards,

Joel Lipman
www.joellipman.com

Related Articles

Joes Revolver Map

Joes Word Cloud

windows   note   select   database   list   name   report   order   find   first   date   page   license   files   data   table   website   version   display   source   script   solution   following   error   file   joomla   user   search   server   parameter   added   where   need   work   used   would   time   program   google   uploaded   using   value   creator   mysql   zoho   form   could   function   code   system   JoelLipman.Com

Accreditation

Badge - Certified Zoho Creator Associate
Badge - Certified Zoho Creator Associate

Donate & Support

If you like my content, and would like to support this sharing site, feel free to donate using a method below:

Paypal:
Donate to Joel Lipman via PayPal

Bitcoin:
Donate to Joel Lipman with Bitcoin - Valid till 8 May 2022 3QnhmaBX7LQSRsC9hh6Je9rGQKEGNQNfPb
© 2021 Joel Lipman .com. All Rights Reserved.