Search This Blog

2014-09-18

yet some more efficiency improving shortcuts

-- win 7 and other shortcuts
http://www.shortcutworld.com/en/win/Windows_7.html

-- win 7 quick navigation between all the opened windows
Ctrl + Alt + Tabl - keeps the alt + tab windows without having to keep the
alt key down , use the keys keys to navigate to the correct window

-- Oracle Sql Developer format sql ( beutify ) shortcut
Ctrl + F7

2014-09-17

vim-cheat-sheet

" file: vim-cheat-sheet.vim v.1.1.0 docs at the end
"  
" how-to start vim in the shell by opening list of files 
vim -o `echo /a/dir/with/conf/and/sh/files/*.{sh,conf}`
" if something goes owry do always press the Esc key several times before proceeding !!!
" how-to exit without saving (the hyphen meaning is the same for all commands )
:q! 
" open all the perl files in the current directory 
vim *.pl  
" how-to open a new buffer with the ouptput from a shell command
find `pwd` -name '*.pm' -exec grep -inHP 'sub [a-zA-Z0-9]*\s+\{' {} \; | vim -
 
" press Esc press w to save the file ,q to quit , ! for not saving anything
:wq!
" how-to open a directory 
:e /etc/
" how-to go one dir level up when dir is open
-
 
"how-to save the changes  were editing. For saving the file under a different name, specify the file name.
:w 
" how-to list the opened files ( called in vim buffers ) 
:ls
" how-to close a buffer  
:bd <<buffer_number>>
" how-to close the current buffer 
:bd 
"Write the file and exit.
:wq 
" how-to reload the current buffer if the file has been edited by another tool
:edit
" how-to get help 
:help 
 
" hit N to jump to the previous match 
 
" === START NAVIGATION in the contents of the files === 
" enter normal mode first , note this navigation keys work only in normal and visual modes
Esc
" how-to go one line below
j
" how-to go one line up 
k 
" how-to go one character left in normal mode  
l
" how-to go one character right in normal mode
h
" how-to backward a word in normal mode 
B
" how-to foward a word in normal mode 
e
" how-to go the begining of the document in normal mode ( Ctr+Home on Win )
gg
" how-to go the end of the document ( Ctrl + End on Win )  
G
" how-to jump to line number xxx ( for example line number 34 ) 
34G 
" how-to jump back from where you were in the previous time
' -(Press ' twice ) jump back to line (where you came from) 
" go to the beginning of the line 
^
" jump to the end of a line.
$ 
" jump to the beginning of a word.
b 
" go backwards a word 
B
" jump to a stringToSearchFor
:/stringToSearchFor
" how-to jump to the next occcurence of the stringToSearchFor  
n
" hit n to jump to the next match 
N
 
" jump to the matching brackets [](){} .
" go on top of the bracket and press 
%
" === STOP NAVIGATION in the contents of the files === 
 
" === START EDITING ===
" to be able to write you have to enter the insert mode
Esc,i
" now you could start typing, the arrow keys work as well ;) ! 
" how-to delete text
" how-to delete the current line 
dd 
" or 
:d 
" how-to delte 3 lines in normal mode
3d
" === STOP EDITING ===
 
 
" === START COPY PASTE ===
" how-to select text and copy paste
" first enter into visual mode 
Esc,v 
" navigate within the text with the navigation keys ( see above ) 
j,k,l,h
" than yank the selected into the register ( Ctrl + C in Windows - copy to clipboard ) 
y 
" or to cut it after the selection into the register ( Ctrl + X in Windows - cut it into the clipboard ) 
d 
" in visual mode Yank the current line. You do not need to highlight it first.
yy or :y or Y 
" Esc to run into the normal mode,navigate to the place where to paste the text and paste it: 
p 
" Undo the last actionUndo the last action
u 
" Redo the undone action 
Ctrl + r
" === STOP COPY PASTE === 
 
 
" START working with buffers 
" list the currently opened buffers ( or files for writing ) 
:ls
" open a file as another bugger
:e /path/to/file3
" switch again to the first bugger 
:b 1
" switch to the next buffer without saving the current one 
:bn!
" switch to the previous file buffer ( your will be prompted to save it if you have not done it yet)
:bp  
" go to the next buffer
:cnext 
" open the file under the cursor in Normal mode
gf 
" opens a new file in a new window
:split /usr/share/some.file  
 
" STOP working with buffers 
 
" START SEARCH AND REPLACE 
" how-to search and replace text with confirmation before each replace 
:%s/search_for_this/replace_with_this/c
 
" how-to Find and replace 
:%s/foo/bar/g Replace every occurrence of the word foo with bar in the whole file.
 
" how-to remove all the lines containing the string "clear"
:%s/^.*clear$\n//gi  
 
" For all lines in a file, find "string_to_find" and replace with "string_to_replace" for each instance on a line. Ask for confirmation 
:%s/string_to_find/string_to_replace/gc 
 
"  - For all lines between line marked "a" (ma) and line marked "b" (mb), find string "fff" and replace with string "rrrrr" for each instance on a line. Case insensitive. 
:'a,'bs/fff/rrrrr/gi
" For all lines in a file, delete blank spaces at end of line. 
:%s/*$/ 
" For all lines in a file, move last field delimited by ":" to the first field. Swap fields if only two.
:%s/\(.*\):\(.*\)/\2:\1/g 
 
" how-to get help on search and replace commands  
:help substitute 
:help pattern 
 
" STOP SEARCH AND REPLACE 
 
 
" where vim sets the settings of the "sessions" 
vim ~/.viminfo
 
" How to edit the colors of the current color scheme: 
" 1. Check the name of your current color scheme located at: /root/.vimrc or /home/usrname/.vimrc (attention come kind of aliasing ... )
:colorscheme elflord
 
" 2. Edit the current colorsheme 
locate elflord.vim 
" search for the section containinng the colors would like to edit
/comments
 
" 3. Pick a HEX number for the color of the comments you would prefer to have .. "40FF00 (google color table )
" Enters the file under the cursor into the editor in you commend line (normal mode).
Ctrl-R Ctrl-F 
 
Ctrl-R Ctrl-A Enters the text from the editor in you commend line (normal mode).
" As most other *nix applications, you can also pause Vim with Ctrl-z, which will drop you back to the shell. When you are re finished, you can resume Vim with fg. (This is a feature of the shell, not a Vim feature.)
 
 
" how-to show the current directory
:!pwd"  
 
" START folding 
" jump to the beginning char of the folding - for example the brackets of the function 
e
" change to visual mode
Esc , v
" select till the end of the desired folding region 
%
" to fold the region type the following command
:fold
" to open the just closed folded region 
zo 
" to close it back again 
zc 
" STOP folding
 
 
   " START indending 
   " enter normal mode
   Esc
   " enter visual mode
   v
   " select the text you would like to intent / shift wit the navigation keys
   " shift with 
   >>
   " or 
   <<
   " STOP indending 
 
 
" START SETTINGS 
" all of those could be set in the ~/.vimrc file 
 
" adjust the amount of space on pressing tab
:set tabstop=3
" set cursor showing matching brackets 
:set showmatch 
" set the appearance on the left side for the line numbers
:set number
" unset the numbers 
set nonu
" set syntax highlighting 
:set 
" set a specific type of syntax 
:set syntax=html
" set the heigt of the window 
:set winheight=90 
" set the default shift width 
:set sw=3
" set the columnn width to 120 characters 
:set co=120 
" set wrapping 
:set wrap 
 
" STOP SETTINGS 
 
 
" how-to create your own syntax highting 
" create your customizable syntax highlighting dir
mkdir -p ~/.vim/syntax/
" find the syntax file for the language 
locate perl.vim
" copy the already existing syntax file to this folder
cp -c /usr/share/vim/vim73/syntax/perl.vim ~/.vim/syntax/
" edit the "overriding " syntax file 
: e ~/.vim/syntax/perl.vim
 
 
" START COMMANDS 
" Any UNIX command can be executed from the vi command line by typing an "!" before the UNIX command. 
" how-to insert the current date 
:r! date +"\%Y-\%m-\%d \%H:\%M:\%S"
" how-to insert the full paths from the current directory 
:r! find `pwd`
" navigate onto a file path and press 
gf
" to openn it into another buffer
" STOP COMMANDS 
 
 
 
"START Mappings 
"show all the mappings 
:map
" the keyboard shortcuts performing user defined commands which could be saved in the .vimrc file
" Ctrl + Tab for switching to the next buffer
map <C-Tab> :bn!<CR> 
 
map <f4> :bn! <CR> :bd "<CR>  Ctrl + F4 - for closing the current buffer
" STOP Mappings 
 
" 
 
" enable jump-to definition feature 
" in the shell cd /my/src/root/dir/
" generate the tags file for this root src
" ctags -R -n --fields=+i+K+S+l+m+a 
" in vim
":ta <<name_of_func_to_search_for>>
":ts ? shows the list.
":tn ? goes to the next tag in that list.
":tp - goes to the previous tag in that list.
":tf ? goes to the function which is in the first of the list.
":tl ? goes to the function which is in the last of the list.
 
" set left indent to 3
:le 3
 
" find in files recursively 
:vimgrep /'DocPage'/ **/*.pm
:vimgrep /doBuild/ `find . -type f -name '*.pm' -o -name '*.pl'`
" type than to open the found in files window
:cw
 
 
" Purpose: 
" to provide a tutorial-like vim-cheat-sheet 
" 
" sources 
http://www.yolinux.com/TUTORIALS/LinuxTutorialAdvanced_vi.html
http://en.wikibooks.org/wiki/Learning_the_vi_Editor/Vim
" 
" VersionHistory
" 1.1.0 --- 2013-04-24 13:43:27 --- Yordan Georgiev --- added jump to with ctags
" 1.0.1 --- 2012-12-26 11:58:40 --- Yordan Georgiev --- enhancements 
" 1.0.0 --- 2012-12-25 10:30:16 --- Yordan Georgiev --- Initial creation 
"
" eof file: vim-cheat-sheet.vim

2014-09-13

how-to handle files with spaces and funny chars with xargs

find sfw/gen -type f -print0 | xargs -0 -I "{}" zip zip_file.zip "{}"

2014-09-10

how-to run powershell from the mintty.exe cygwin terminal


  1. Download the cygwin installer and place in your Windows Path
  2. Run the following commands from the cmd shell

    • setup-x86_64.exe -n -q -s http://cygwin.mirror.constant.com -P binutils
    • setup-x86_64.exe -n -q -s http://cygwin.mirror.constant.com -P bzip2
    • setup-x86_64.exe -n -q -s http://cygwin.mirror.constant.com -P cygwin
    • setup-x86_64.exe -n -q -s http://cygwin.mirror.constant.com -P gcc-core
    • setup-x86_64.exe -n -q -s http://cygwin.mirror.constant.com -P gcc-g++
    • setup-x86_64.exe -n -q -s http://cygwin.mirror.constant.com -P gzip
    • setup-x86_64.exe -n -q -s http://cygwin.mirror.constant.com -P make
    • setup-x86_64.exe -n -q -s http://cygwin.mirror.constant.com -P unzip
    • setup-x86_64.exe -n -q -s http://cygwin.mirror.constant.com -P zip
  3. Download the console.exe utility from  git hub
  4. Unzip it somewhere. 
  5. Go to the <<somewhere>>winpty-master\ from the cygwin bash shell
  6. Run the following commands
    • ./configure
    • make
  7. Copy the console.exe , winpty.dll , winpty-agent.exe to your cygwin bin dir
  8. Start the power shell from the cygwin terminal: console.exe powershell.exe
  9. Or if you are not admin :  console.exe powershell.exe -ExecutionPolicy bypass

Labels

perl (41) Cheat Sheet (25) how-to (24) windows (14) sql server 2008 (13) linux (12) oracle (12) sql (12) Unix (11) cmd windows batch (10) mssql (10) cmd (9) script (9) textpad (9) netezza (8) sql server 2005 (8) cygwin (7) meta data mssql (7) metadata (7) bash (6) code generation (6) Informatica (5) cheatsheet (5) energy (5) tsql (5) utilities (5) excel (4) future (4) generic (4) git cheat sheet (4) html (4) perl modules (4) programs (4) settings (4) sh (4) shortcuts (4) поуки (4) принципи (4) Focus Fusion (3) Solaris (3) cool programs (3) development (3) economy (3) example (3) freeware (3) fusion (3) logging (3) morphus (3) mssql 2005 (3) nuclear (3) nz (3) parse (3) python (3) sftp (3) sofware development (3) source (3) sqlplus (3) table (3) vim (3) .Net (2) C# (2) China (2) GUI (2) Google (2) GoogleCL (2) Solaris Unix (2) architecture (2) ascii (2) awk (2) batch (2) cas (2) chrome extensions (2) code2html (2) columns (2) configuration (2) conversion (2) duplicates (2) excel shortcuts (2) export (2) file (2) free programs (2) informatica sql repository (2) linux cheat sheet (2) mssql 2008 (2) mysql (2) next big future (2) nsis (2) nz netezza cheat sheet (2) nzsql (2) ora (2) prediction (2) publish (2) release management (2) report (2) security (2) single-click (2) sqlserver 2005 (2) sqlserver 2008 (2) src (2) ssh (2) template (2) tools (2) vba (2) video (2) xlt (2) xml (2) youtube videos (2) *nix (1) .vimrc (1) .virmrc vim settings configs (1) BSD license (1) Bulgaria (1) Dallas (1) Database role (1) Dense plasma focus (1) Deployment (1) ERP (1) ExcelToHtml (1) GD (1) GDP (1) HP-UX (1) Hosting (1) IDEA (1) INC (1) IT general (1) ITIL management bullshit-management (1) IZarc (1) Java Web Start (1) JavaScript anchor html jquery (1) Khan Academy (1) LINUX UNIX BASH AND CYGWIN TIPS AND TRICKS (1) Linux Unix rpm cpio build install configure (1) Linux git source build .configure make (1) ListBox (1) MIT HYDROGEN VIRUS (1) OO (1) Obama (1) PowerShell (1) Run-time (1) SDL (1) SIWA (1) SOX (1) Scala (1) Services (1) Stacks (1) SubSonic (1) TED (1) abstractions (1) ansible hosts linux bash (1) ansible linux deployment how-to (1) ansible yum pip python (1) apache (1) apache 2.2 (1) application life cycle (1) architecture input output (1) archive (1) arguments (1) avatar (1) aws cheat sheet cli (1) aws cli (1) aws cli amazon cheat sheet (1) aws elb (1) backup (1) bash Linux open-ssh ssh ssh_server ssh_client public-private key authentication (1) bash perl search and replace (1) bash stub (1) bin (1) biofuels (1) biology (1) books (1) browser (1) bubblesort (1) bugs (1) build (1) byte (1) cas_sql_dev (1) chennai (1) chrome (1) class (1) claut (1) cmdow (1) code generation sqlserver (1) command (1) command line (1) conf (1) confluence (1) console (1) convert (1) cool programs windows free freeware (1) copy paste (1) copy-paste (1) csv (1) ctags (1) current local time (1) cygwin X11 port-forwarding mintty xclock Linux Unix X (1) cygwin bash how-to tips_n_tricks (1) cygwin conf how-to (1) data (1) data types (1) db2 cheat sheet (1) db2 starter ibm bash Linux (1) debt (1) diagram (1) dictionaries (1) digital (1) disk (1) disk space (1) documentation (1) dos (1) dubai (1) e-cars (1) electric cars (1) electricity (1) emulate (1) errors (1) exponents (1) export workflow (1) extract (1) fast export (1) fexp (1) file extension (1) file permissions (1) findtag (1) firewall (1) for loop (1) freaky (1) functions (1) fusion research (1) german (1) git gitlab issues handling system (1) google cli (1) google code (1) google command line interface (1) gpg (1) ha (1) head (1) helsinki (1) history (1) hop or flop (1) host-independant (1) how-to Windows cmd time date datetime (1) ibm db2 cognos installation example db deployment provisioning (1) ideas (1) image (1) informatica oracle sql (1) informatica repo sql workflows sessions file source dir (1) informatica source files etl (1) install (1) isg-pub issue-tracker architecture (1) it management best practices (1) java (1) jump to (1) keyboard shortcuts (1) ksh (1) level (1) linkedin (1) linux bash ansible hosts (1) linux bash commands (1) linux bash how-to shell expansion (1) linux bash shell grep xargs (1) linux bash tips and t ricks (1) linux bash unix cygwin cheatsheet (1) linux bash user accounts password (1) linux bash xargs space (1) linux cheat-sheet (1) linux cheatsheet cheat-sheet revised how-to (1) linux how-to non-root vim (1) linux ssh hosts parallel subshell bash oneliner (1) london (1) make (1) me (1) metacolumn (1) metadata functions (1) metaphonre (1) method (1) model (1) movie (1) multithreaded (1) mysql cheat sheet (1) mysql how-to table datatypes (1) n900 (1) nano (1) neteza (1) netezza bash linux nps (1) netezza nps (1) netezza nps nzsql (1) netezza nz Linux bash (1) netezza nz bash linux (1) netezza nz nzsql sql (1) netezza nzsql database db sizes (1) non-password (1) nord pol (1) nps backup nzsql schema (1) number formatting (1) nz db size (1) nz table count rows (1) nzsql date timestamp compare bigint to_date to_char now (1) on-lier (1) one-liners (1) one-to-many (1) oneliners (1) open (1) open source (1) openrowset (1) openssl (1) oracle PL/SQL (1) oracle Perl perl (1) oracle installation usability (1) oracle number formatting format-model ora-sql oracle (1) oracle templates create table (1) oracle trigger generic autoincrement (1) oracle vbox virtual box cheat sheet (1) oracle virtual box cheat sheet (1) outlook (1) parser (1) password (1) paths (1) perl @INC compile-time run-time (1) perl disk usage administration Linux Unix (1) perl modules configuration management (1) permissions (1) php (1) picasa (1) platform (1) postgreSQL how-to (1) powerShell cmd cygwin mintty.exe terminal (1) ppm (1) predictions (1) prices (1) principles (1) productivity (1) project (1) prompt (1) proxy account (1) public private key (1) publishing (1) putty (1) qt (1) read file (1) registry (1) relationship (1) repository (1) rm (1) scala ScalaFmt (1) scp (1) scripts (1) scsi (1) search and replace (1) sed (1) sendEmail (1) sh stub (1) shortcuts Windows sql developer Oracle (1) sidebar (1) silicon (1) smells (1) smtp (1) software development (1) software procurement (1) sofware (1) sort (1) sql script (1) sql_dev (1) sqlcmd (1) sqlite (1) sqlite3 (1) sshd (1) sshd cygwin (1) stackoverflow (1) stored procedure (1) stub (1) stupidity (1) subroutines (1) svn (1) sysinternals (1) system design (1) tail (1) tar (1) temp table (1) templates (1) teradata (1) terminal (1) test (1) testing (1) theory (1) thorium (1) time (1) tip (1) title (1) tmux .tmux.conf configuration (1) tmux efficiency bash (1) tool (1) ui code prototyping tips and tricks (1) umask Linux Unix bash file permissions chmod (1) url (1) urls (1) user (1) utility (1) utils (1) vb (1) vbox virtual box cheat sheet (1) vim perl regex bash search for string (1) vim recursively hacks (1) vim starter (1) vim-cheat-sheet vim cheat-sheet (1) vimeo (1) visual stuio (1) warsaw (1) wiki (1) wikipedia (1) window (1) windows 7 (1) windows 8 (1) windows programs (1) windows reinstall (1) windows utility batch perl space Windows::Clipboard (1) wisdoms (1) workflow (1) worth-reading (1) wrapper (1) xp_cmdshell (1) xslt (1) youtube (1)

Blog Archive

Translate with Google Translate

My Blog List