Showing posts with label Hotmail. Show all posts
Showing posts with label Hotmail. Show all posts

Saturday, May 1, 2021

How to extract Gmail, Yahoo, Hotmail, Live etc. in excel:

 (Suppose you applied the following formula in D column)

=RIGHT(A2,LEN(A2)-SEARCH("@",A2))

Now to the next of D column you can write following formula to separate specific ESP

=if(d2=”gmail.com”,”Gmail”,if(d2=”live.com”,”Live”,if(d2=”hotmail.com”,”Hotmail”,if(d2=”yahoo.com”,”Yahoo”,if(d2=”aol”,”Aol”)))))


Upload file to server using Power Shell Command

 scp file_name.zip username@server_ip/server_address:/directory_path