Visual Studio – Delete blank lines

Visual Studio | Posted by Marvin Sugirin June 1st, 2011

Visual Studio has ability to delete empty lines in replace operation using regular expressions.
1.Click Ctrl-H (quick replace)
2. Tick “Use Regular Expressions”
3. In Find specify ^$\n
4. In Replace box delete everything.
5 Click “Replace All”
All empty lines will be deleted.

Regular expression for empty line consist of

Beginning of line ^
End of line $
Line break \n

Note that normally in Windows an end of line  indicated by 2 characters CRLF – Carriage Return (CR, ASCII 13, \r) Line Feed (LF, ASCII 10, \n).

Addition from  Kenneth at 6/18/2009:
A regex to remove blank lines that are/aren’t *really* blank (i.e. they do/don’t have spaces):   ^:b*$\n

source:

http://geekswithblogs.net/mnf/archive/2008/03/04/remove-empty-lines-in–text-using-visual-studio.aspx

New Office Documents appearing as zip in IE

Development, Web | Posted by Marvin Sugirin May 11th, 2011

Add the following lines to the .htaccess file:

AddType application/vnd.ms-word.document.macroEnabled.12 .docm
AddType application/vnd.openxmlformats-officedocument.wordprocessingml.document docx
AddType application/vnd.openxmlformats-officedocument.wordprocessingml.template dotx
AddType application/vnd.ms-powerpoint.template.macroEnabled.12 potm
AddType application/vnd.openxmlformats-officedocument.presentationml.template potx
AddType application/vnd.ms-powerpoint.addin.macroEnabled.12 ppam
AddType application/vnd.ms-powerpoint.slideshow.macroEnabled.12 ppsm
AddType application/vnd.openxmlformats-officedocument.presentationml.slideshow ppsx
AddType application/vnd.ms-powerpoint.presentation.macroEnabled.12 pptm
AddType application/vnd.openxmlformats-officedocument.presentationml.presentation pptx
AddType application/vnd.ms-excel.addin.macroEnabled.12 xlam
AddType application/vnd.ms-excel.sheet.binary.macroEnabled.12 xlsb
AddType application/vnd.ms-excel.sheet.macroEnabled.12 xlsm
AddType application/vnd.openxmlformats-officedocument.spreadsheetml.sheet xlsx
AddType application/vnd.ms-excel.template.macroEnabled.12 xltm
AddType application/vnd.openxmlformats-officedocument.spreadsheetml.template xltx

Unix – Zip a Folder

OSX, Software, Unix | Posted by Marvin Sugirin February 7th, 2011

In the shell use the following command:

zip -r filename directory

IE6 and IE7 on Windows 7 (or any platform)

Software, VMWare, Windows 7 | Posted by Marvin Sugirin November 10th, 2010

Here’s the scenario:
You are running Windows 7, but need to test a website or a web application for Cross Browser Compatibility. In Windows 7, you can’t rollback to IE6, what are your options? There are many ways to do this, but here are some.

Option 1 (MS Solution)
First download an image from Microsoft (http://www.microsoft.com/downloads/en/details.aspx?FamilyId=21EABB90-958F-4B64-B5F1-73D0A413C8EF&displaylang=en). There are many options to choose from and this is great!

Now it’s up to you how you handle the downloaded VHD. If you have Windows 7 Professional or Ultimate, you can follow the instructions to install Virtual PC (http://www.microsoft.com/windows/products/winfamily/virtualpc/default.mspx).

If you only have Windows 7 Home Premium, but you have VMWare Workstation/Server, you can convert the disc by using StarWind V2V Image Converter (http://www.starwindsoftware.com/converter). Once you have converted it, simply create a new Virtual Machine and choose the existing VMDK.

Option 2 (Web solution)
You can you Spoon! (http://www.spoon.net/)This requires only a plugin installation and you’re good to go to run various different browsers. An issue I was having with this was using IE6. Some pages it simply won’t display for any reason and if you change security settings, you might not be able to see the changes.

New Jetta 2011

Jetta 2011, Volkswagen | Posted by Marvin Sugirin October 30th, 2010

So, I finally got my first own (leased) car! I decided to go with the VW Jetta 2011 (MK6). At first I was struck by the price on the ads, $15,995. But I knew the price was just for the basic version with a 2.0 engine and steel rims with hub caps. That didn’t really struck my interest, going up in the class, I decided to go with the SEL version of the car.

The version I wanted, black exterior and black interior was not in the dealer, so they had to locate the car and ship it over from the port, which took about a week.

Here are some pictures on the first day. It was picked up last night, so this is the first time it hit sun light.

HSTS – Strict Transport Security

Security, Web | Posted by Marvin Sugirin September 16th, 2010

HTTP Strict Transport Security (HSTS) is the new security standard for websites. PayPal is one website that is using this standard for their HTTPS site.

Read the rest of this entry »

VMWare Fusion: Lost Connection to Internet

Mac, OSX, Software, VMWare | Posted by Marvin Sugirin September 16th, 2010

On a Mac, using VMWare Fusion is close to a must in the business world, due to all the VPN vendors that do not support Mac OSX natively.

What I experienced in the past is that after a while of using the VMWare, you notice that your internet connection gets cut off. Restarting the VM doesn’t help either nor disabling/enabling the network adapter.

This is because the DNS/NAT service of VMWare Fusion stopped working.

Simply restart the service and you are back up. Here’s the how:

1. Open a Terminal

2. Type in the following command:
sudo /Library/Application\ Support/VMware\ Fusion/./boot.sh –restart

3. Enter your admin password and hit enter

4. Go into your VM and disconnect / connect the NAT adapter connection.

5. You’re back online !

Formula to Explode a Cell

Excel, Software | Posted by Marvin Sugirin September 15th, 2010

So, you have a big list of contacts but one column has both, first and last name, but you need them separately, because you want to upload it to a CRM system or somewhere else. This example shows the name being formatted in this way: “John Doe”. The formulas will extract the left name and place it into a First Name column and the last name into a different column.

First Name column would look like this: =LEFT(A1,FIND(“,”,A1)-1)

Last Name column would look like this: =RIGHT(A1,LEN(A1)-FIND(” “,A1))

After that, just select all the cells down and hit CTRL + D.

Reference: http://www.ozgrid.com/forum/showthread.php?t=64545&page=1

Use Unix commands in Windows

Software, Windows 7 | Posted by Marvin Sugirin September 14th, 2010

In order to use Unix Commands in Windows, you will need to download CoreUtils from GnuWin32 (Sourceforge: http://sourceforge.net/projects/gnuwin32/ | Direct Download). Install it and add it to your Windows Path Library. Read the rest of this entry »

New Computer Build

Hardware, New Build | Posted by Marvin Sugirin September 13th, 2010

I was looking into replacing my old laptop, which for the standards back then was top of the line and even now it is still not too bad. Still – I needed something more current. After doing intense research on what components to get, I decided to go with the basic components first, making sure it has everything it needs for the next components to come.

Motherboard: ASUS P6X58D Premium
CPU: Intel(R) Core(TM)  i7 930 2,8Ghz @ 4Ghz
Fan: Thermalright Ultra 120 eXtreme
RAM: OCZ Gold XTC (OCZ3G1600V2G) Triple 2GB – specifications are off, but this is what Everest tells me
PSU: Fatal1ty 750W
Graphics: nvidia GTS 8800 (my brother’s old graphic card he left me behind)
HDD: 2x 500gs
Case: Cooler Master Cosmos 1000

These were pretty much the basic components to use. I choose an i7 over an i5, just because of the limitation that i5 CPU/Motherboard have – they do not support dual 16x-PCIe, which makes would slow down a SLI or CrossFire configuration.
The motherboard I was struggling with. Only choose ASUS over the EVGA x58 FTW3, because they didn’t had any in stock (was shopping in Microcenter). Also one of the reps told me that ASUS has better overclocking abilities.

That’s it for now, soon I will update to Dual 460s and to Raid0 SSDs, which more storage on a different array. Furthermore I wanted to add backplanes to the HDD inlets of the Cosmos case. Let’s see how that one goes. So far – I’m pretty happy for the performance that I’m getting out of the basics.