migration_data | Migrate data along with schema migrations | Data Migration library

Am i guessing it right? Do you want to select multiple columns by applying distinct on one column only? If yes here is the solution. If not, tell me precisely

Don't use [regex]::Escape() to escape the replacement string in a -replace operation - it isn't a regular expression, and \ has no special meaning inside of it.

Instead, manually escape $ chars. as $$, because $ does have special meaning in the replacement operand, namely to refer to results from the matching operation, notably capture-group results, as detailed in this answer.

Performing this manual escaping with -replace is somewhat tricky, because $ is special both in a regex and in the replacement operand, with different escaping requirements: