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.

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: .

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
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.

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...

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:

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:
Account ID,Name,Phone,Record ID
  1.  Account ID,Name,Phone,Record ID 
  2.  1457102000000135533,Joel,00441234567890,1457102000000165989 
  3.  1457102000000135566,Stanley,01709123456,1457102000000167543 
  4.  1457102000000135608,David,00331234567890,1457102000000166795 
My Excel:
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 

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

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).

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

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

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).

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
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
Unable to send or receive messages for the Hotmail (someone) account.

Subject 'your Microsoft Issue'
Server Error: 3219
Windows Live Mail Error ID: 0x8DE00005

Server Error: 3219
Windows Live Mail Error ID: 0x8DE00005
  1.  Unable to send or receive messages for the Hotmail (someone) account. 
  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. 
  8.  Server Error: 3219 
  9.  Server: 'https://mail.services.live.com/DeltaSync_v2.0.0/Sync.aspx' 
  10.  Windows Live Mail Error ID: 0x8DE00005 

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
  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
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

Category: Excel :: Article: 635

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.

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).

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

Credit where Credit is Due:




Kind Regards,

Joel Lipman

Related Articles

Joes Revolver Map

Joes Word Cloud

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


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

Donate & Support


Donate to Joel Lipman via PayPal

© 2022 Joel Lipman .com. All Rights Reserved.