Welcome to Shinjan’s Site

1. Go to Start>Programs>Microsoft Excel to open the application. Go to File>New and open a new spreadsheet.

2. Go to Tools>Customize and select it.

3. A pop-up menu window called “Customize” will appear, click on the “Toolbar” tab and select the toolbar where you want the macro button to appear. For this tutorial, we want the macro button to be accessible and visible in the “Standard” toolbar, so check the box for the Standard toolbar.

4. Now click on the “Commands” tab and select a category – the kind of function you will be creating as a button. Go down and select “macros.” The Commands window to the right of the pop-up window appears with two options: Custom Menu Item or a Custom Button.

5. Click on the “Custom Button” (it looks like a happy face) option and drag it to the standard toolbar (located at the top of the screen under the different menu options - File, Edit, etc.), place it right next to the “Save” button so it is easy to locate.

6. Now click on the new macro button and a pop-up window called “Assign Macro” will appear. Here select the actual macro that will be assigned to this button, so for this tutorial we’ll use one already created called “PERSONAL.XLS!.ht” macro and hit OK.

7. Finally, we’ll test the new custom macro button. Go to File>New to open a new spreadsheet, and click on the newly created macro button located on the standard toolbar to the right of the “Save” button. After clicking the button, you will see the names of ten training managers automatically appear.

Great! wasn’t it super easy. You can basically follow the same steps to add a button for any function other than a macro. Remember to keep practicing because the more you do it, the better you will get.        

1. Open a new workbook.
2. From the Tools menu, choose Customize, as shown in Figure A.

Figure A

1. Click the Commands tab and then scroll down the left-hand Categories column and select Macros (see Figure B).
2. You’ll see Custom Button in the Commands box. Click, hold, and drag the custom button onto any toolbar and release, as shown in Figure B.

Figure B

1. Right-click the new button and choose Assign Macro.
2. Choose HeaderFooter and click OK. You may now change the button icon by right-clicking the button, choosing Change Button Image, and clicking on another icon, as shown in Figure C.

Figure C

1. Close the Customize dialog box.

You may now run your macro by clicking the button you’ve created. It will be available from all workbooks.

Create a macro button in Microsoft Word
Creating a macro button in Microsoft Word is similar to creating one in Excel. The following directions were written using Microsoft Word 2000. Instructions for other versions may differ slightly. Before starting the steps below, I created a macro, named PasteText, to paste unformatted text in Word documents. To create a macro button:

1. Open a new document.
2. From the Tools menu, choose Customize.
3. Click the Commands tab and then scroll down in the Categories box and select Macros (see Figure D). You’ll see the names of any macros you’ve created in the Commands box on the right-hand side.
4. Click, hold, and drag your macro onto any toolbar and release, as shown in Figure D. A button with the name of the macro will appear on the toolbar.

Figure D

1. To associate an icon with this button, right-click it, choose Change Button Image, and click on any icon (see Figure E).

Figure E

1. Next, right-click the button and choose Default Style. Your button will now appear as an icon only.

You may run your macro by clicking the button you’ve created. It will be available from all documents.

contents of a variable to a regular expression, use the =~ operator. Regular expressions are also used by perl built in functions such as grep and split, and by the s operator.

Perl 6, currently under development, will support grammars and rules rather than regular expressions. Grammars and Rules will take pattern matching to a whole new level, and tools will be available to covert code - in other words, rules and grammars will do everything that the old Regular Expressions didn’t, and more.

After the closing / of your regular expression, you can add one or more modifiers to change its behaviour.

The following Perl functions and operators use regular expressions

The above lists show the most commonly used elements of Perl regular expressions, and are not exhaustive.

In Perl, you can change the / regular expression delimiter to almost any other special character if you preceed it with the letter m (for match); if you change to ( { or [, the balancing end expression character becomes ) } or ].

sub trim($){

        my $string = shift;

        $string =~ s/^\s+//;

        $string =~ s/\s+$//;

        return $string;

}

$body =~ s/(\s)/(++$count%15==0)?”\n”:$1/ige;

use Cwd;
my @files;
opendir (DIR, $dirname) or die $!;
my @dir = readdir DIR;

foreach my $item1 (@dir){
    if ($item1 ne “..” || $item1 ne “.”){
        push @files ,$item1;
    }
}
closedir DIR;

Validate if the string passed in a valid email or not

returns true or false 

var emailfilter=/^\w+[\+\.\w-]*@([\w-]+\.)*\w+[\w-]*\.([a-z]{2,4}|\d+)$/i

returnval=emailfilter.test(<Email address to be tested >);

in the below code  the 2 can be replaced  with n number and \s is for space and \n for new line charecter 

$string  =~ s/(\s)/(++$count%2==0)?”\n”:$1/ige;

#!/usr/local/bin/perl

my $file_name = “/apps/intranet/ns-home/Apache_Server/Public/TechCouncil/TIITC/2006/data/a0756159_1148893709_Karnataka%20Map.pdf”;

open(FILE, “< $file_name”) or die (”$!”);

while (<FILE>) {

            $File .= $_;

}

close FILE;

print “Content-Type: application/pdf”, “\n”;

print “Content-Disposition: Attachment; filename=Abc.pdf”, “\n\n”;

print $File;

Go to the topmost level and then run this comand

find . -exec grep -l “mankad” ‘{}’ \; > /user/x0032906/Public/Files_containing_string_mankad.csv