By Joel 'Jaykul' Bennett on 07-Oct-2007
Well, just for a change, lets cut straight to the script ( 5pm EST Sunday): Function Convert-Delimited([regex]$from,[string]$to) { process { $_ = $_ -replace "(?:`"((? 
?:[^`"]|`"`"))+)(?:`"$from|`"`$))|(? (?:.(?!$from))*.)(?:$from|`$))","Þ`$1`$2Þ$to" $_ = $_ -replace "Þ(?:$to|Þ)?`$","Þ" $_ = $_ -replace "`"`"","`"" -replace "`"","`"`"" $_ = $_ -replace "Þ((?:[^Þ`"](?!$to))+)Þ($to|`$)","`$1`$2" $_ [...]
Posted in Huddled | Tagged Import-Csv, PowerShell, RegEx, Scripting