Wednesday, February 12, 2014


Here is some example to convert or find out the day name from a date.





Note The second variable indicates the day of the week that the week begins. For example, the variable "1" indicates that the week starts on Sunday, while the variable "2" indicates that the week starts on Monday.



Functions:

=WEEKDAY(A2,1)
=CHOOSE(WEEKDAY(A2),"Sun","Mon","Tue","Wed","Thu","Fri","Sat")
=TEXT(A2,"dddd")
=TEXT(A2,"dd")
=TEXT(A2,"ddd")

Tuesday, December 03, 2013

MS Excel Tips.

Advance MS Excel: Part-1. Commands - CONCATENATE, CHAR, TEXT, FIND, MID, MID, UPPER, REPLACE, SUBSTITUTE


1.       Join multiple fields in one field. Or adding Prefix to a field. [See – Fig:2]
Syntax: = CONCATENATE(text1, text2, ... text_n) e.g. =CONCATENATE (A2, B2) or =CONCATENATE ("ABC",123)



2.       ASCII value to Character. [See – Fig: 1]
Syntax : = CHAR(ascii_value) CHAR(filed) e.g. =CHAR (65) or  =CHAR (A2)



3.       Converting Numbers to a fixed length number with a specific format. If you need to make all numbers to 7 digit number, follow the following syntax. [see – Fig: 3 & Fig: 4]
Syntax: = TEXT( value, format ) e.g. TEXT(123,"0000000") or =TEXT(A2,"0000000") 



4.       Getting the position of a character from a text/string. For this “Find” function is used and it is case sensitive.  [See – Fig:5]
Syntax: = FIND(find_text,within_text,start_num) e.g. 
=FIND(" #",A2,1)


5.       Getting Substring from a String/text. For this “MID” function is used. [See – Fig:6]
Syntaxt: =MID( text, start_position, number_of_characters ) e.g. =MID(A2, 1, 19) or =MID(A2,1,FIND(" #",A2,1)-1) or =MID("Happy", 1, 2)


Note: If you need only leftmost characters or substring then you can simply use “LEFT” function.  E.g. =LEFT(A2, 19). If you need only Rightmost Characters or substring simply use “RIGHT” function. E.g. =RIGHT(A2,5)

6.       Convert letters/text  to Lowercase
Syntax: = LOWER(text) e.g.=LOWER(A2)

7.       Convert letters/text  to Uppercase.
Syntax: = UPPER(text) e.g.=UPPER(A2)
Note: Only Capitalized the first letter. Use “PROPER” function. E.g. =PROPER(A2)


8.       Replace a substring to a string/text or Updating characters/substring in a text/string. [See- Fig:7]

Syntax: = REPLACE(old_text,start_num,num_chars,new_text) e.g. =REPLACE(A2,5,5,"Big Bang")



Note: If you want to replace a specific word then you can simply use “SUBSTITUTE” function. It is casesensetive. [See- Fig: 8]
Syntax: = SUBSTITUTE(text,old_text,new_text,instance_num) e.g. =SUBSTITUTE(A2, "music", "Big Bang")


Enjoy



Wednesday, November 20, 2013

Unhide files or folder, Unhide system files and folder, Unhide Files in Virus Infected Pendrive Using Command Prompt.

Click start > run > type : ” cmd ” then type the command:
attrib d:\*.* /d /s -h -r -s
Note: “d:” is your drive letter, You can change to specific drive you want.


Displays or changes file attributes.
ATTRIB [+R | -R] [+A | -A ] [+S | -S] [+H | -H] [[drive:] [path] filename] [/S [/D]]

+
Sets an attribute.
-
Clears an attribute.
R
Read-only file attribute.
A
Archive file attribute.
S
System file attribute.
H
Hidden file attribute.
/S
Processes files in all directories in the specified path.
/D
Process folders as well.

Tuesday, October 01, 2013

Sunday, July 21, 2013




Humayun Ahmed All Books List:

A
* Ami Ebong Koekti Projapoti | size : 6.68 mb
* Ami-ee Misir Ali | size : 10.46 mb
* Ashabori (Part 1) | size : 5.14 mb
* Ashabori (Part 2) | size : 4.83 mb 
* Ayna Ghor (Part 1) | size : 2.22 mb
* Ayna Ghor (Part 2) | size : 2.21 mb
* Ayna Ghor (Part 3) | size : 2.09 mb
* achinpur | size : 5 mb
* Ahok | size : 2.42 mb
* alebele | size : 86 kb
* Amar Ache Jol | size : 3.11 mb
* Anonto Nakhotro | size : 2.88 mb | page :
* Aporahnyo | size : 3.23 mb | page :
* Aj chitrar biye | size :8 mb | page :
B
* Baghbondi Misir Ali (Part01) | size : 5.03 mb | page :
* Baghbondi Misir Ali (Part02 | size : 5.1 mb | page :
* Baghbondi Misir Ali (Part01 | size : 5.3 mb | page :
* Baghbondi Misir Ali (Part01 | size : 5.3 mb | page :
* Bohubrihi (Part 1) | size : 5.59 mb | page :
* Bohubrihi (Part 2) | size : 5.06 mb | page :
* Brishti Bilash (Part 1) | size : 5.73 mb | page :
* Bhoy (Part 1) | size : 4 mb | page :
* Bhoy (Part 2) | size : mb | page :
* Brihonnola | size : 4.27mb | page :
* Brishti Bilash (Part 2) | size : 4.44 mb | page :
* Bohubrihi (Part 3) | size : 3.78 mb | page :
* Bashor | size : 4mb | page :
* Botol Vut | size : 4.13 mb | page :
C
* Chole Jay Boshonter Din (04 | size : 4.66 mb | page :
* Cheleta | size : 8.24 mb | page :
* Chayabithi | size : 6.30 mb | page :
D
* Dorjar Opashe | size : 4.4 mb | page :
* Dekha Na Dekha | size : 2.25 mb | page :
E
* Eki Kando! | size : 3.89 mb | page :
* Ei Shubhro Ei | size : 4.23 mb | page :
H
* Himur Babar Kothamala | size : 2.4 mb | page :
* Himur Hate Koyekti Nilpoddo | size : 2.31 mb | page :
* Himur Rupali Ratri | size : 2.74 mb | page :
I
* IREENA (Part 1) | size : 4.06 mb | page :
* IREENA (Part 2) | size : 4.51 mb | page :
J
* Jalil Shaheber Petition | size :67 kb | page :
K
* Krisnopokkho | size : 242 kb | page :
* Kobi (Part 3) | size : 3.42 mb | page :
* Kobi (Part 4) | size : 3.87 mb | page :
* Kichukkhon (Part 1) | size : 4.16 mb | page :
* Kichukkhon (Part 2). | size : 4.28 mb | page :
* Kutu Mia (Part 1) | size : 4.36 mb | page :
M
* Moyurakkhir Tire Prothom himu | size : 900 kb | page :
* Mrinmoyeer Mon Valo Nei | size : 1.80 mb | page :
* Mishir Alir Omimangshito 07 | size : 3.83 mb | page :
* Mishir Alir Omimangshito | size : 4.19 mb | page :
* Maddhanya (Part 1) | size : 4.42 mb | page :
* Maddhanya (Part 2). | size : 4.16 mb | page :
* Maddhanya (Part 3) | size : 4.26 mb | page :
* Maddhanya (Part 4) | size : 3.91mb | page :
* Mrinmoyee (Part 1) | size : 4.44 mb | page :
* Mrinmoyee (Part 2) | size : 4.4 mb | page :
* Mrinmoyee (Part 3) | size : 2.39 mb | page :
* Magic Munshi | size : 4.62 mb | page :
* Meger chaya | size : 8 mb | page :
* Magic Munshi | size : 4.62 mb | page :
* Meger chaya | size : 8 mb | page :
N
* Nirbason | size : 2.19 mb | page :
O
* Onnodin | size : 3.68 mb | page :
* Onish | size : 2.88 mb | page :
* Onno Vuban | size : 2.45 mb | page :
P
* Paap | size : 1.3 mb | page :
R
* Rodon Vora E Bosonto | size : 3.16 mb | page :
* rupar palanka | size : 1.72 mb | page :
S
* Se O Nortoki | size : 1.94 mb | page :
* Shobai Gechhe Bone | size : 5.46 mb | page :
* Shob Jatra | size : 660 kb | page :
T
* Tumi amai deke chile chutir nimontrone | size : 4.44 mb | page :
U
* Uralpankhi | size : 5 mb | page :

Monday, June 03, 2013

Source Link: Click Here

How to send mail from Localhost with XAMPP and mercury/32

Had tried to make php mail() work on localhost. But had failed. So gave up. This was around 8 months back. Now again some days back had to use the Php mail function on one project. This time I had the liberty to test my code on an external web server, but i tried again to make it work on my localhost.

A lot of google searching and some simple steps, I could make it work.So here sharing my experience with you. Hope this helps someone like me.

I use XAMPP as my local web server on my Windows machine. For php mail() function to work on the localhost, you need a SMTP mail server.

Requirements

A Web server : Here we use the xampp package. You can download it from here. It is very easy to install and does not require any expertise.
A Mail server : Mercury/32 Mail Transport System is an excellent mail server bundled with XAMPP. So no need to search for any other mail server.
A Mail Client : You need to have a mail client to receive mails sent from localhost or basically from your Mercury/32 mail server. Mail clients include outlook express, thunderbird, Eudoramail etc. For this tutorial I will be using the default mail client available with Windows system , ie the outlook express.

The Steps to Configure Mercury/32 mail server
The following steps will guide you through the working of mail function on localhost.
1) You need to start the localhost web server. The XAMPP in this case.



2) By default XAMPP will not start the mercury mail server. So you need to click on start to start the mercury/32 on the XAMPP control panel.


3) Click on the Admin Button next to mercury on XAMPP control panel. This will open the Mercury/32 Admin Panel. Click on Configuration -> Manage Local users.


4) Create a New User. Let
Username : root
Password : root
5) Next, from the Mercury/32 Admin panel, Go to Configurations -> Mercury SMTP server and make the following Changes.
IP Interface to use : 127.0.0.1
Listen to TCP/IP port : 25
Announce Myself as : 127.0.0.1


6)Next, from the Mercury/32 Admin Panel , Go to Configurations -> Mercury POP 3 Server and fill in the following details.
Listen to TCP port : 110
IP Interface to use : 127.0.0.1


7) Next, from the Mercury/32 Admin Panel, Go to Configurations - > MercuryE SMTP client Configuration , and make the following changes
Identify Myself as : 127.0.0.1
Name server : 127.0.0.1


8) Next step is from the Mercury/32 panel go to Configuration -> Mercury D pop3 client and there create a new Account. Click on “ADD” and then enter the following details for “Edit POP3 mailbox definition” dialog box.
POP3 Host : 127.0.0.1
Username : root
Password : root
And then click on save.


This finishes Configuration of your Mercury/32 Mail transport system.

We now have to configure a mail client, so as to receive mails. We will use the windows default mail client, the outlook express. The following steps will guide you to create a user account on outlook express.

Steps to set up OUTLOOK EXPRESS



1)Open Outlook express and then click on Tools -> Accounts -> Add, and then click on Mail


2)For new Internet account on outlook express , create a new user
Enter display name: root

Enter email Id: root@localhost.com

Then click Next. On the Internet Connection wizard,
Select POP3 for my incoming mail server.
For Incoming mail (POP3, IMAP, HTTP) server, enter
127.0.0.1
For Outgoing (SMTP) server, enter
127.0.0.1

Click on Next and then , enter the following fields
Account name : root
Password : root
Click on finish and you are ready to Go.

Once you have finished creating a account on Outlook express , send a test mail to yourself.

You can now test your php code to check if your script is working successfully or not.You can try this script. Copy the code and save it in a file for eg mail.php. Save this file in your root folder , for xampp it will be in your htdocs folder.

//php code to send mail,
//author : idrish laxmidhar
//Use this code to send a test mail from your localhost.

$to = "root@localhost.com";
$subject = "Hi!";
$body="test".PHP_EOL;
$body.="Hello World. If all went well then you can see this mail in your Inbox".PHP_EOL;
$body.="Regards".PHP_EOL;
$body.="Idrish Laxmidhar".PHP_EOL;
$body.="http://i-tech-life.blogspot.com".PHP_EOL;

$headers = "From: root@localhost.com";

if (mail($to, $subject, $body, $headers)) {
echo("Message successfully sent!
");

} else {
echo("Message delivery failed...
");

}
?>


Run the script. If all went well, the script should execute successfully. Check your email. You should receive an e-mail.

Well this finishes the tutorial. Hope it helps someone out there.

background