Powershell replacing part of field returned from Select-Object

Question

I'm extracting fields from Active Directory and piping that into a .csv file, My Select-Object command returns the fields by name. My problem is some of these fields contain carriage return and line feed information I want to remove before piping it into the .csv

Example:

Select-Object SamAccountName,displayName,info | ConvertTo-CSV -NoTypeInformation | 
Out-File -Append -FilePath $Filepath -Encoding unicode

How can I intercept and amend the 'info' field before firing it to .csv?

Thanks.

Akim · Accepted Answer · 2012-07-19 12:01:51Z

4

You could remove carriage return and line feed using regex. Try next snippet:

Select-Object -property SamAccountName, DisplayName, Info |
    % {
        $_.SamAccountName = [regex]::Replace($_.SamAccountName, "(`n|`r)+"," ", "Multiline");
        $_.DisplayName= [regex]::Replace($_.DisplayName, "(`n|`r)+"," ", "Multiline");
        $_.Info = [regex]::Replace($_.Info, "(`n|`r)+"," ", "Multiline");
        return $_;
    } | 
    ConvertTo-CSV -NoTypeInformation | 
    Out-File -Append -FilePath $Filepath -Encoding unicode

edited Jul 19, 2012 at 12:01

answered Jul 19, 2012 at 10:35

Akim

8,7592 gold badges35 silver badges49 bronze badges

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

3 Comments

Grimster Over a year ago

Hi Akim, thanks for the response.Not sure what's going on there but I now get ÿþ as an output, just once - that's the new content of the entire document rather than the 3k lines expected.

Akim Over a year ago

sorry, i'd forget to add return $_;. Try snippet now

Grimster Over a year ago

I still receive the same output. No worries though I've resorted to adding a line to manipulate the finished file to remove the information I needed to. Thanks very much for your assistance.

Stephen Turner · Accepted Answer · 2022-07-25 16:02:22Z

1

You can intercept the output using a calculated property:

Select-Object SamAccountName,displayName,{$_.info.replace("`r", "").replace("`n", "")} 
    | ConvertTo-CSV -NoTypeInformation 
    | Out-File -Append -FilePath $Filepath -Encoding unicode

The backtick ` allows you to insert special characters `r is carriage return and `n is new line.

answered Jul 25, 2022 at 16:02

Stephen Turner

7,3526 gold badges54 silver badges71 bronze badges

Collectives™ on Stack Overflow

Powershell replacing part of field returned from Select-Object

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related