Powershell + in a string not valid

Question

I have to replace a phone number in a document but when there is no phone number from mu user I have to delete this row The default document looks like this:

company
street
T: +00 xxx xxx xxx  #phone
F: +00 xxx xxx xxx  #Fax
M: +00 xxx xxx xxx  #Mobile

When for example a user has no mobile phone I have to delete this row

$content = $content -replace "M:",""
$content = $content -replace "+00",""
$content = $content -replace "xxx xxx xxx",""

But I'm getting this error

The regular expression pattern +39 is not valid.
At line:65 char:1
+ $content = $content -replace "+39",""
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidOperation: (+39:String) [], RuntimeException
    + FullyQualifiedErrorId : InvalidRegularExpression

How can I now delete this row when power shell doesn't want my + in a string

Delete the row:

After deleting successful the mobile number document looks like this:

company
street
T: +00 xxx xxx xxx  #phone
F: +00 xxx xxx xxx  #Fax

more information

But it should look like this

company
    street
    T: +00 xxx xxx xxx  #phone
    F: +00 xxx xxx xxx  #Fax
    more information

can you provide an example line where phone number needs to get deleted? — Martin Brandl
– Martin Brandl, Commented Jun 8, 2016 at 13:50

Andrey Marchuk · Accepted Answer · 2016-06-08 14:14:18Z

2

Don't use regex replace, but use String.Replace:

$content = $content.Replace("M:","")
$content = $content.Replace("+00","")
$content = $content.Replace("xxx xxx xxx","")

This should work for you:

$content = Get-Content $filepath | foreach-object { if (!$_.StartsWith("M:")) { $_ } }
$content

edited Jun 8, 2016 at 14:14

answered Jun 8, 2016 at 13:40

Andrey Marchuk

13.5k4 gold badges41 silver badges53 bronze badges

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

5 Comments

Felix ccad Over a year ago

thanks that worked and how can i delete the row no is there space between the next rows

Felix ccad Over a year ago

after the row where the mobile number is are other rows with information's. When I set the row with the mobile number to "" (nothing) there is one row without anything in how can i delete this row that there is no more space between the row Fax and the next row

Andrey Marchuk Over a year ago

Is it possible to get it as a string array instead of 1 string?

Felix ccad Over a year ago

i dont know i'm beginner in powershell i have a rtf document and get the content with : $content = Get-Content $filepath -raw

Andrey Marchuk Over a year ago

see update, but regex option could be a bit better here

Martin Brandl · Accepted Answer · 2016-06-08 13:53:23Z

1

You could also use a regex to filter them:

$content | Where { $_ -notmatch '^M: \+00' }

edited Jun 8, 2016 at 13:53

answered Jun 8, 2016 at 13:52

Martin Brandl

59.4k16 gold badges151 silver badges190 bronze badges

3 Comments

briantist Over a year ago

Damn, beat me to it!

Martin Brandl Over a year ago

@briantist sorry :-p.

Martin Brandl Over a year ago

Probably its how you retrieve the $content variable (you have to omit the -raw parameter to get an array. However, you already got an comprehensive answer.

Collectives™ on Stack Overflow

Powershell + in a string not valid

2 Answers 2

5 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related