Monday, March 28, 2011

HTML <button> tag

<button> tag is introduced in HTML 4.0. Almost all the new versions of the browsers support this tag.

This tag takes 4 attributes namely:

1. name

2. type

3. disabled

4. value

“type” attribute specifies the type of button. It takes 3 values. They are : Submit, Reset, Button.

If it is a “submit” button and the browser is IE then it submits the text present in between the button start and end tags. All other browsers submit the content of “value” attribute.

Sunday, March 27, 2011

Combine Multiple Text Files in Unix

To combine multiple text files in Unix we need to use the “cat” command.
Syntax: cat filename1 filename2 filename3 >> newfilename

Example: cat a.txt b.txt >> c.txt

In the above example we are combining the contents of the 2 text files in to a third text file. The new file “c.txt” contains the contents of “a.txt” and then the contents “b.txt”.

If the command “cat b.txt a.txt >> c.txt” is used then the new file contains the contents of “b.txt” first and then the contents of “a.txt”.

We can combine any number of text files to a single file. All we need to do is to specify the file names before the “>>” symbol which is the output redirection operator in Unix.

Thursday, March 24, 2011

String Comparision in Excel


  1. To compare strings in excel we need to use the EXACT function.
  2. EXACT function takes two arguments. If both the arguments are same(Case Sensitive) then the result will be TRUE else the result is FALSE.
  3. Syntax:  EXACT(arg1,arg2)
Below is a sample excel sheet on which we use the function.

  • =EXACT(A1,B1)  returns FALSE
  • =EXACT(A1,”Krishna”) returns FALSE
  • =EXACT(A1,”Krishna”) returns TRUE
  • =EXACT(“Krishna”,”Krishna”)  returns TRUE
  • =EXACT(“Krishna”,”Krishna”) returns FALSE