I am trying to compare two csv together using powershell. My question is there a way where powershell can compare two csv files against each other as long as there is a matching word then it would allow it as in the file. For Example:
ulrich schnauss - ...Passing By
Vitamin String Quartet - Bad Romance
vitas - opera 2
If Powershell able to match even if there are extra word or symbols? Such as opera would get pick up and match with result2.csv even if it has a ? or capitalize.
Powered by IDERA