A quick note on Web.config file in the ASP.NET project. It is worth noting that the file is a XML File (read this for more info – https://msdn.microsoft.com/en-us/library/ff400235.aspx )
One issue that hindered my process earlier was that the content in the value has special character it in, particularly, one of my SQL server’s password has a special character in it.
I would have to go and replace them accordingly. For instance, my password is <Password1& (note that < and ” is inclusive), i would have to change it to
You can refer to the list here – https://en.wikipedia.org/wiki/List_of_XML_and_HTML_character_entity_references
Microsoft releases new iterations of Microsoft Office suite every three years for desktop and Microsoft Office 365 is the subscription based cloud version of their Office software. Earlier in 2016, Microsoft released the 2016 edition of Office and some updates to Office 365 which added new features in Excel. Some very useful functions like the CONCAT and TEXTJOIN functions are added which make concatenating or joining text very easier with multiple cells or strings in your spreadsheet. These functions are only available in the latest Office 2016 desktop installation and Office 365 subscription. To show these new functions, here is the Excel CONCAT and TEXTJOIN function tutorial. I am breaking them into 2 different tutorials for ease of access.
Through the Office Excel CONCAT function, you can connect two or more text in different cells in your spreadsheet. When you connect two text, they are just joined together with no separation or space between them. Here is the tutorial on how to use Excel CONCAT function:
The format of the Excel CONCAT function is:
CONCAT(text1, text2, … , textN)
Where “text1” is the first string or cell and “textN” is the nth string or cell which you want to concatenate.
You can view more Office Excel Tutorials in the link too!
I was attempting to “edit” .htaccess file to make some url redirection for a page and I realised I wasn’t unable to locate the file in my web root. The first instinct is that I didn’t have any .htaccess file and I decided to create one. However, I was given an error that ERROR: Could not create file “.htaccess” in path. File exists..
This indeed confused me as I cannot locate the file. Upon further probing, I realised what was wrong. You have to check on the option Show Hidden Files (dotfiles) when you open up File Manager in your cPanel.
I am doing one of the tutorial in CS2100 in NUS SoC and one of the questions require us to convert between binary and gray codes.
I have decided to write a simple tutorial on how to convert from binary to gray codes.
What is Gray Code?
“….is a binary numeral system where two successive values differ in only one bit. The reflected binary code was originally designed to prevent spurious output from electromechanical switches.”
What is Binary Code?
A binary code represents text or computer processor instructions using the binary number system’s two binary digits, 0 and 1.
The whole concept on how to do the conversion between the 2 number system heavily uses the XOR truth table.
I am sure this will be useful to some of my audience who may have similar experience as me.
There was this one day when I accidently click on some stuffs(which till date is still unknown to me what I did) and I accidently changed a setting which I shouldn’t had.
This causes my address bar to be reading from right to left as you can see below