I have a script that executes a stored procedure on a MSSQL server and creates an CSV. The problem I am having is that one of the database fields in the query is a free form text filed and in many entries it contains CRLF's. This is causing the CSV to not format correctly. I am looking to add a to my script a method to remove these extra CRLF's. I would be grateful for any assistance.
Thanks for the feed back. I have looked over the examples and tried to do some experimenting and so far have come up short.
The CSV I am creating from the SQL query is being pipe delimited so what I really need to do is to remove any CRLF's that are between the pipes.
Any help would be greatly appreciated!!!!
So replace `r`n in all strings with nothing if you end up with one long line at the end add + "`r`n" at the end of each line.
Note the single and double quotes.
$My_String = $My_String.Replace("`r`n",")
# adding Carriage return + New line to end of the string if all the lines are double spaced remove the below line.
$My_String = $My_String + "`r`n"
I think this would be of help
Escape characters, Delimiters and Quotes https://ss64.com/ps/syntax-esc.html
`a Alert bell/beep
`f Form feed (use with printer output)
`n New line
`r Carriage return
`r`n Carriage return + New line
`t Horizontal tab
`v Vertical tab (use with printer output)