Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bwagner
Starting Member
1 Post |
 Posted - 2009-01-07 : 14:41:27
|
| I'm not really sure how to go about this project, so I thought I'd throw it out there.I have two .txt files that are stored in csv format. The first file is set up as:PhoneNumber1,PhoneNumber2,FirstName,LastName,AccountNumberThen the second file is set up like this:AccountNumber,FirstName,LastNameWhat I'm looking to do is any time an account number from File 2 matches an account number from File 1, to have that row removed from File 1. I need for the file to stay saved as a csv .txt file. Please let me know if this is possible, and how to go about tackling this problem. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Deleting rows from txt files