Technology Insights

Gentoo: Paste Into Vi Issue, Each Line Gains More Spaces To The Left

My Linux distribution of choice is CentOS so that is where I typically spend time. Recently though I have been working for a project that runs on a Gentoo Linux server. So far I really like Gentoo though there are some things that I am used to that are totally different. One minor issues I have had is how vi/vim (vi IMproved) handles text that is pasted into it. Every time I was pasting data into a file I was editing with vi. Initially I thought it must have been some odd formatting coming from the file I was copying the text from however I ruled this out quickly when I pasted into notepad first to remove all formatting and then into vi and sure enough the spaces on the left still existed. Below I explain the issue, provide an image of a shell window showing the issue, and how to resolve the problem.

Technology Insights

Copy and Paste Screen Captures Into Photoshop Not Working, Adobe Photoshop CS4 Clipboard Problem

Recently I was trying to paste a screenshot created using print screen into Adobe Photoshop CS4 on Windows XP but nothing would happen. I use print screen to create screenshots on a regular basis and then paste the results into Photoshop so I can describe how to resolve basic issues on a computer to people. I have never had a problem until this time so I figured it must be a configuration setting or something similar causing the issue.

Technology Insights

Import And Track All Of Your Xbox Live Friends On Your iPhone With 1337pwn

Tracking the online status off your Xbox Live friends is easy on your iPhone or iPod Touch using 1337pwn. This application will allow you to not only see the online status of your Xbox Live friends but you can also view their avatars, games played, gamer points broken down by game, and easily send messages to your friends (opens a Safari browser window). Below are a couple images of the application in action to give you an idea of how user friendly it is.

Technology Insights

Restore One Table with psql from a pg_dump PostgreSQL Backup

Backing up and restoring PostgreSQL is fairly easy using pg_dump and psql. One more complicated scenario I have run into is doing a complete database backup with pg_dump and at some point down the road needing to just split out one table and restore it. This can be a pain because of how the pg_dump organizes the .sql file it outputs. I have found the best way to do this is to use pg_dump to backup one table to understand the format of what is needed for a restore. Then search the .sql file that was output from the full pg_dump output and split out the necessary data to restore into one table. Below I provide some examples as well as syntax to use for backing up and/or restoring PostgreSQL using pg_dump and psql.

Technology Insights

How to Merge Multiple Excel Fields Together, Merge Excel Cells Together

Its fairly easy to merge Microsoft Excel fields together but you have to be aware of formulas and then with how to pull that data out of the formula to save it on its own. I used this to merge title, first name, and last name together. Follow the directions below and you should have no problems merging Excel fields together.

1. New Column: Add the below formula to a new column.

=CONCATENATE(A1,” “,B1,” “,C1)

Microsoft Excel Formula for Merge