After searching everywhere I'm still unable to find a solution. I have two text documents, one is a list of names the other is coordinates. both documents start each line with an 8 digit code. I want to lookup 8 digit line code from File1 and copy the line contents to only code matches in File2.

Staff Member

I did it in powershell, it's pretty basic, but it lets you specify Input1 (Unique entry file), Input2(Multiple instances file) -Output (merged output txt file) and -Index # the index for the column you want to match by. You would just need to save the code in a <Filename>.ps1 file and open an elevated Powershell promtp and type Set-ExecutionPolicy Unrestricted so you can run the script.