monkeystudio IDE on Fedora 12.. IDE of choice

<a href="http://www.monkeystudio.org/" target="_blank">Monkey IDE is a Free <a class="zem_slink freebase/en/cross-platform" title="Cross-platform" rel="wikipedia" href="http://en.wikipedia.org/wiki/Cross-platform">crossplatform <a class="zem_slink freebase/en/qt" title="Qt (framework)" rel="homepage" href="http://qt.nokia.com/">Qt 4 IDE

MonkeyStudio is a crossplatform <a class="zem_slink freebase/en/integrated_development_environment" title="Integrated development environment" rel="wikipedia" href="http://en.wikipedia.org/wiki/Integrated_development_environment">Integrated Development Environment ( IDE ) aiming to become a <a class="zem_slink freebase/en/rapid_application_development" title="Rapid application development" rel="wikipedia" href="http://en.wikipedia.org/wiki/Rapid_application_development">Rapid Application Development ( RAD ) environment. MonkeyStudio runs everywhere Qt 4.4.0 ( minimum required to build it ) is available as a <a class="zem_slink freebase/en/library" title="Library (computing)" rel="wikipedia" href="http://en.wikipedia.org/wiki/Library_%28computing%29">shared library. It is extensible via a great and powerful <a class="zem_slink freebase/en/plugin" title="Plug-in (computing)" rel="wikipedia" href="http://en.wikipedia.org/wiki/Plug-in_%28computing%29">plugin system which help make it do nearly anything you want and support virtually any kind of project type for which a plugin exists or is created. The primary goal of MonkeyStudio was to manage Qt4 projects as best as possible, it directly uses .pro files and does not create intrusive or unsightly <a class="zem_slink freebase/en/configuration_file" title="Configuration file" rel="wikipedia" href="http://en.wikipedia.org/wiki/Configuration_file">configuration files. MonkyStudio is also a multi language <a class="zem_slink freebase/en/source_code_editor" title="Source code editor" rel="wikipedia" href="http://en.wikipedia.org/wiki/Source_code_editor">code editor too ( javascript, xml, … ).

Continue reading

Search & replace with find & ed

function sr() {

declare pattern replacement name usage
declare -i pvar=0 rvar=0 tvar=0

usage='usage: sr [-t ] [-n name] [-p pattern] [-r replacement] [– ] [dir1 dir2 …]'

# cf. <a href="http://bsdpants.blogspot.com/2007/02/option-ize-your-shell-scripts.html">http://bsdpants.blogspot.com/2007/02/option-ize-your-shell-scripts.html

while [[ "${1:0:1}" == '-' ]] ; do

[[ "${1}" == '–' ]] && { shift; break; } # – marks end of options

unbound variable – bash completion not working and having issues with other stuff like command not found.

I generally use vi/vim for all my practical purposes of working with text files. And I have all the vi/vim plugins required to work with the files. This causes the following to be in the skeleton for all the bash scripts that I create:

set -o nounset                              # Treat unset variables as an error

With this all the unbound variables as errors and was problem with all the shell scripts that was being sourced in the startup of bash. So all I had to do was remove this from all the startup scripts and then from the skeleton of the bash script in vim :).

swaks – Swiff army nife for SMTP

If you are having issues with the <a class="zem_slink freebase/en/simple_mail_transfer_protocol" title="Simple Mail Transfer Protocol" rel="wikipedia" href="http://en.wikipedia.org/wiki/Simple_Mail_Transfer_Protocol">SMTP Server, then sometimes you just wish you had a swiss army knife to test the same and then you would not have to spend your precious time on some silly mistake that you may have made. Your wish is now fulfilled.

<a class="zem_slink freebase/en/military_of_switzerland" title="Military of Switzerland" rel="wikipedia" href="http://en.wikipedia.org/wiki/Military_of_Switzerland">Swiss Army Knife SMTP: A <a class="zem_slink freebase/en/command_line_interface" title="Command-line interface" rel="wikipedia" href="http://en.wikipedia.org/wiki/Command-line_interface">command line SMTP tester.  Swaks can test various aspects of your SMTP <a class="zem_slink freebase/en/server" title="Server (computing)" rel="wikipedia" href="http://en.wikipedia.org/wiki/Server_%28computing%29">server, including <a class="zem_slink freebase/en/transport_layer_security" title="Transport Layer Security" rel="wikipedia" href="http://en.wikipedia.org/wiki/Transport_Layer_Security">TLS and AUTH.

Continue reading

Openoffice.org and/or Excel useful tips.

Today I was working on Excel sheets and had to do quite a lot of manipulations. Here are some of those:

1. Find the value of the cell whose number is stored in another cell.

You can use the indirect function.

Here is example:

<a href="http://blog.amit-agarwal.co.in/wp-content/uploads/2010/08/screenshot_0022.jpe"><img class="size-full wp-image-959" title="indirect" src="http://blog.amit-agarwal.co.in/wp-content/uploads/2010/08/screenshot_0022.jpe" alt="indirect" width="354" height="98" />

That&#8217;s cool and easy.

2. Indirect reference with some constant values.

You can add constant and cell id with &#8221;&&#8221;

bash script with sql to get the number of records from multiple tables.

Here is the bash script:

#!/bin/sh
names[1]=errorlog
names[2]=amit1log
names[3]=amit2log
names[4]=amit3log
names[5]=amit4log
j=1
echo $1
for i in $( sqlplus amit/passwd@tns @get_count.sql |sed  -n &#8217;/COUNT/,/Disconnected/p&#8217;|sed &#8217;/COUNT/ d&#8217;|sed &#8217;/—/ d&#8217;|sed &#8217;/Disconnected/ d&#8217;|tr &#8217;n&#8217; &#8217; &#8217;  )
do
temp=${names[$j]}
let count=30-${#temp}
for ((I=1; I <= $count ; I++))
do
printf &#8221; &#8221;
done
echo  &#8221;${names[$j]}    : $i&#8221;
# echo $j
let j=j+1
done
echo
echo

and the required sql script:

select count() from errorlog;
select count() from amit1log;
select count() from amit2log;
select count() from amit3log;
select count(*) from amit4log;
quit;

Continue reading

Built-in lists in vim

<a class="zem_slink freebase/en/vimscript" title="Vimscript" rel="wikipedia" href="http://en.wikipedia.org/wiki/Vimscript">Vimscript provides excellent support for operating on collections of <a class="zem_slink freebase/en/data" title="Data" rel="wikipedia" href="http://en.wikipedia.org/wiki/Data">data, a cornerstone of programming. In this third article in the series, learn how to use Vimscript&#8217;s built-in lists to ease everyday operations such as reformatting lists, filtering sequences of filenames, and sorting sets of line numbers. You&#8217;ll also walk through examples that demonstrate the power of lists to extend and enhance two common uses of <a class="zem_slink freebase/en/vim" title="Vim (text editor)" rel="homepage" href="http://www.vim.org/">Vim: creating a <a class="zem_slink freebase/en/user_defined_function" title="User-defined function" rel="wikipedia" href="http://en.wikipedia.org/wiki/User-defined_function">user-defined function to align assignment operators, and improving the built-in text completions mechanism.