Powershell replace command not removing newline

Question

I have text that prints out like this:

mdbAppText_Arr: [0]: The  cover is open. {goes to next line here}
Please close the cover. and [1] Backprinter cover open 
46

I tried getting rid of the newline after open., and it's still there. Any idea of a better way or fix for what I'm doing? I need to get rid of the newline because it's going to a csv file, and messing up formatting (going to newline there).

This is my code:

$mdbAppText_Arr = $mdbAppText.Split("|")                        
$mdbAppText_Arr[0].replace("`r",";").replace("`n",";").replace("`t",";").replace("&",";") 
#replace newline/carriage return/tab with semicolon
if($alarmIdDef -eq "12-7")
{
     Write-Host "mdbAppText_Arr: [0]: $($mdbAppText_Arr[0]) and [1] $($mdbAppText_Arr[1]) "
     [byte] $mdbAppText_Arr[0][31]
}

I've been looking at:

replace

replace - this one has a link reference to lookup in the asci table, but it's unclear to me what column the byte equivalent is in the table/link.

I'm using PowerShell 5.1.

Mathias R. Jessen · Accepted Answer · 2022-01-18 17:13:16Z

4

-replace is a regex operator, so you need to supply a valid regular expression pattern as the right-hand side operand.

You can replace most newline sequences with a pattern describing a substring consisting of:

an optional carriage return (\r? in regex), followed by
a (non-optional) newline character (\n in regex):

$mdbAppText_Arr = $mdbAppText_Arr -replace '\r?\n'

answered Jan 18, 2022 at 17:13

Mathias R. Jessen

178k13 gold badges175 silver badges234 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Sage Pourpre Over a year ago

Expanded to encompass removal of ampersands / tabs (as per OP initial sequence '-replace "&|\t|\r?\n",';''

Mathias R. Jessen Over a year ago

@SagePourpre Looks like an answer waiting to be written :)

Michele Over a year ago

Thanks a lot! Works great! :)

Collectives™ on Stack Overflow

Powershell replace command not removing newline

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related