Run a Process in the Foreground or the Background  

Sunday, November 11, 2012

To run a process in the background:
[command]  &

To suspend a foreground process and place it in the background, use the following steps:

  1. Press CTRL+Z
  2. Enter: bg 

To bring this background process to the foreground again,
  1. enter: fg

AddThis Social Bookmark Button

Posted in by Alex Yap | 0 comments

Email this post

How to customize BASH profile?  

If you wanted to customize your .profile, .bashrc or .bash_profile, visit this link, awesome references:

http://stefaanlippens.net/my_bashrc_aliases_profile_and_other_stuff

or

http://www.linuxfromscratch.org/blfs/view/6.3/postlfs/profile.html


Changing directory colors:
http://www.geekgumbo.com/2011/11/04/changing-the-directory-color-in-the-bash-shell/


AddThis Social Bookmark Button

Posted in , by Alex Yap | 0 comments

Email this post

How to use vlookup for microsoft Excel?  

Monday, July 2, 2012

Wondering how to use vlookup to search for a value?

Scenario 1:
Search a target cell to find out the existance from another column.


In the example above, we use the formula

=VLOOKUP(D3,B:B,1,FALSE)

we are searching cell D3 ('C') against column B (B:B), if exist, return value from B#, FALSE is to find exact match.


Scenario 2:
Search a target cell E8 ('D') against column B8:C10, if exist, return the value from column C.

=abs(h8-f8) to get the differences. ABS value of 0 means E9 value of 5 equivalent to B9 value of 5.


AddThis Social Bookmark Button

Posted in by Alex Yap | 0 comments

Email this post

Subscribe to: Posts (Atom)

Design by Amanda @ Blogger Buster