Link to home
Start Free TrialLog in
Avatar of egoldenberg
egoldenbergFlag for United States of America

asked on

reading and pasting or appending a column from 1 csv file into another csv file with same row count using windows batch or powershell

Need some help with a DOS batch file or powershell script, either will do, Have (2) csv's and need the column of file2.csv appended with file1.csv to create file3.csv, Both source files have same row count. Need to append headers not required.

file1.csv
brown, blue, 123, yellow
purple, black, 456, magenta
pink, teal, 789, grey

file2.csv
alpha
bravo
charlie

outfile.csv
brown, blue, 123, yellow, alpha
purple, black, 456, magenta, bravo
pink, teal, 789, grey, charlie

advTHANKSance
ASKER CERTIFIED SOLUTION
Avatar of oBdA
oBdA

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of egoldenberg

ASKER

Perfect, thank you so much!