Author Archives: ronaldpringadi

Customize your Vim editor using .vimrc

Posted on April 24, 2014 by ronaldpringadi

Quick notes: – imap is for when you are in insert mode – map is when your are in command mode Thus when you are in the insert mode, sometime you need to exit to the command mode first using … Continue reading →

Posted in Linux | Comments Off

Search and replace withing a file

Posted on April 14, 2014 by ronaldpringadi

1234567sed -i -e"s/SEARCH_TEXT/REPPLACE_TEXT/g" FILENAME.txt # another example using bakup sed -i.bak -e"s/SEARCH_TEXT/REPPLACE_TEXT/g" FILENAME.txt # another example using variable sed -i -e"s/\/pathname/\/pathname-$date/g" "filename-"$date".xml"

Posted in Bash, Linux, Operating System | Comments Off

Bash Scripting Basics (Variable Assignment, If, Loop)

Posted on March 20, 2014 by ronaldpringadi

12345678910111213141516171819202122232425262728293031#!/bin/bash ################################################## # Benchmark the processing time when wkhtmltopdf # converts an html file to a pdf file ################################################## if [[ $1 = "" || $2 = "" || $3 = "" ]]; then echo "Usage: … Continue reading →

Posted in Bash, Linux | Comments Off

Compress and Extract Files in Linux

Posted on March 10, 2014 by ronaldpringadi

Extract: .tar.bz2 To extract a tar (Tape ARchiver) file, type the following in the shell prompt: 1tar xvjf yourFileName.tar.bz2 Which will untar it to the current directory. Depending on the file structure that being compressed, it might create sub-directories. Parameters: … Continue reading →

Posted in Bash, Linux | Tagged Linux bash | Comments Off

Using VBA macro for Excel

Posted on January 22, 2014 by ronaldpringadi

Let’s start with something simple. Assume that we have a big spreadsheet and we want to highlight it based on a certain subject — for example, expenses about car. For the sake of the example we’ll keep it short, but … Continue reading →

Posted in Visual Basic | Comments Off

Remote copy using scp

Posted on January 15, 2014 by ronaldpringadi

Do you ever need to copy one file from one server to another? If you have ssh access to the remote server then you can do an scp command like so: 1$ scp remoteUsername@remoteServername:remoteFile localFile

Posted in Linux, Operating System | Tagged Linux | Comments Off

Delete files older than X number of days in Linux

Posted on November 17, 2013 by ronaldpringadi

Say you backup your database daily and you need to delete the old backup files. You can issue the command bellow which will erase any files within the specified directory that are older than 7 days. 1$ find /your/target/directory* -mtime … Continue reading →

Posted in Bash, Linux, Operating System | Comments Off

LDAP basics: Base DN, Search Filters, and a test directory in 5 minutes

Posted on November 5, 2013 by ronaldpringadi

If you’ve ever pasted an LDAP query into a config file without really understanding what each piece means, this post is for you. We’ll cover the two concepts that trip people up most — Base DN and Search Filter — … Continue reading →

Posted in LDAP and Active Directory | Comments Off

Calling a mysql query from linux or dos command line

Posted on October 26, 2013 by ronaldpringadi

There are times when you want to call a mysql command from the bash or dos script then call this script in a scheduler (cron job). The example below will show you how to do so. 1mysql -uYOURUSERNAME -pYOURPASSWORD -DYOURDATABASE … Continue reading →

Posted in Database, Linux, MySQL | Comments Off

Remove all svn directory

Posted on October 20, 2013 by ronaldpringadi

Subversion (SVN) sometimes clutter our source directory by creating .svn folder in each folder or sub folder that we version control. The easiest way to erase them is by using a bash command: 1find . -name ".svn" -type d -exec … Continue reading →

Posted in Linux, Version Control | Comments Off