PowerShell: pulling data from csv and putting into another

[FadeZ]

Hey guys!

 

With powershell I am trying to take two csv files with close to 100 usernames in them, and match the "username" field and fill in the "computer field for matches. Have not been able to make any progress does anyone have any suggestions? 

 

example csv's

 

       CSV1

Username  computers                       Username         computer

-----------    --------------                         ------------     -------------

User1                                                  User1             pc1

User2                                                  User2             pc2

User3                                                  User5             pc5

User4                                                  User8             pc6

User5                                                  User5             pc7

[SCHISCHKA]

import the csv into a database and use SQL? all databases should be able to import/export csv files