TechOnTip Weblog

Run book for Technocrats

Archive for May, 2015

Pick a word from excel cell after/before a character

Posted by Brajesh Panda on May 29, 2015

Pick word(s) from excel after/before a character. Assuming b.panda@abc.com is in A1 cell.

Pick the domain name after @

abc.comĀ =MID(A1,FIND(“@”,A1)+1,256)

Pick the user ID before @

b.panda =LEFT(A1,(FIND(“@”,A1,1)-1))

Advertisements

Posted in Mix & Match | Leave a Comment »

Windows Storage Performance Measurement with DiskSPD

Posted by Brajesh Panda on May 5, 2015

http://blogs.technet.com/b/josebda/archive/2014/10/13/diskspd-powershell-and-storage-performance-measuring-iops-throughput-and-latency-for-both-local-disks-and-smb-file-shares.aspx

Demo1: https://youtu.be/l2QBvNwJx64

Demo2: https://youtu.be/u8ZYhUjSUoI

Posted in Mix & Match, Powershell | Tagged: | Leave a Comment »

 
%d bloggers like this: