posts - 598 , comments - 849 , trackbacks - 247

My Links

News

qrcode

Lance Robinson

Create Your Badge

Lance Robinson is a software engineer in Durham, Chapel Hill, Raleigh, and surrounding areas. More about Lance.

 Subscribe

Tag Cloud

Archives

Post Categories

Blogs

Miscellanous

Noteworthy Stuff

Popular Posts

October 2011 Entries

Merge Delimited Files on a Common Key
Many times I need to merge two separate datasets that have a common key column – for example: dataset 1: ID, Name, Weight, Height dataset 2: ID, Address1, Address2, Phone1, Phone2 I can’t just concat the data together, instead I need the merge to happen around the ID key, so that each ID only has a single row in the result. So, of course I wrote a powershell script to do this for me. Take a look at it below. I called it “Merge-TsvFiles”, but it takes a delimiter as one of its paramters, so you could ......

Posted On Tuesday, October 18, 2011 1:17 PM | Comments (8) |

Powered by: