要件:SQL-Server Bulk Insert 用フォーマットファイルの区切り文字を動的に変更する
Using iFmtFile As StreamReader = New StreamReader("hoge.fmt")
Using oFmtFile As StreamWriter = New StreamWriter("hoge.fmt.tmp")
While (Not (iFmtFile.EndOfStream))
oFmtFile.WriteLine(iFmtFile.ReadLine() _
.Replace(",", RecDelimiter) _
.Replace("\r\n", RowDelimiter))
End While
End Using
End Using