<div>
I'd suggest to change the script that creates the csv, so that you have a proper export that doesn't need to be cleaned afterwards. 
Instead of just exporting the original &quot;AgentsByUri&quot; property, use a calculated property. 
You currently probably have something like 

<pre><code class="code-1 nolinks" id="code-20-42834493-1">Get-Whatever | Select-Object -Property Name, AgentsByUri | Export-Csv ...
</code></pre>
To fix the issue above, just join the array in AgentsByUri: 

<pre><code class="code-1 nolinks" id="code-20-42834493-2">Get-Whatever | Select-Object -Property Name, @{n='AgentsByUri'; e={$_.AgentsByUri -join ', '}}| Export-Csv ...
</code></pre>
</div>

IT Professional

Albert Widjaja

<div>
Hi oBdA, 
 
Tried it, it removed the {} but sip: is still there. 
 
I guess I have to add the sip: somewhere to remove it?
</div>

<div>
Sorry, missed the sip part; the calculated property would be 

<pre><code class="code-1 nolinks" id="code-20-42834508-1">@{n='AgentsByUri'; e={($_.AgentsByUri | ForEach-Object {$_.Split(':')[1]}) -join ', '}}
</code></pre>
</div>

<div>
Get-CsRgsAgentGroup | Select-Object -Property Name, @{n='AgentsByUri'; e={($_.AgentsByUri | ForEach-Object {$_.Split(':')[1]}) -join ', '}} 
 
This brought name of the group but the AgentsByUri came empty without any result. 
<a href="https://filedb.experts-exchange.com/incoming/2019/04_w14/1416720/RGS.jpg" target="_blank" class="file-inline" title="RGS.jpg (26 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>RGS.jpg</a>
</div>

RGS.jpg

<div>
What did your initial script look like?
</div>

<div>
This one worked and removed {} only 
 

<pre><code class="code-1 nolinks" id="code-20-42834542-1">Get-CsRgsAgentGroup | Select-Object -Property Name, @{n='AgentsByUri'; e={$_.AgentsByUri -join ', '}}
</code></pre>
</div>

<div>
That looks like my first suggestion; your &quot;real&quot; initial script should be different, otherwise you shouldn't have had the &quot;{}&quot; around the address list.
</div>

<div>
Original one is this 
 
Get-CsRgsAgentGroup | select name,{$_.AgentsByUri} | Sort name
</div>

<div>
Sorry, can't test this with the original cmdlet. 
From what I can test with an array property containing several 'sip:...' entries, that should work just fine, unless that property is actually an array with only a single element. 
Could you paste the output of these into two [code][/code] blocks: 

<pre><code class="code-1 nolinks" id="code-20-42834569-1">gm -MemberType Property -InputObject (Get-CsRgsAgentGroup | select -first 1).AgentsByUri
</code></pre>
<pre><code class="code-1 nolinks" id="code-20-42834569-2">(Get-CsRgsAgentGroup | select -first 1 -expa AgentsByUri) -replace '[a-z]', '*'
</code></pre>
</div>

<div>
This is the first one gm -membertype's output 
 

<pre><code class="code-10 nolinks" id="code-20-42834622-1">PS C:\Witness\Get-CsConnections.v3.4&gt; gm -MemberType Property -InputObject (Get-CsRgsAgentGroup | select -first 1).AgentsByUri
Get-CsRgsAgentGroup : The pipeline has been stopped.
At line:1 char:39
+ gm -MemberType Property -InputObject (Get-CsRgsAgentGroup | select -first 1).Age ...
+ ~~~~~~~~~~~~~~~~~~~
 + CategoryInfo : NotSpecified: (:) [Get-CsRgsAgentGroup], PipelineStoppedException
 + FullyQualifiedErrorId : Microsoft.Rtc.Rgs.Management.GetOcsRgAgentGroupCmdlet
 


Identity : service:ApplicationServer:SBG-POOL01.domain.net/14869f45-35e1-4c3d-abfe-0912828d2b84
Name : Sales 
Description : Sales 
ParticipationPolicy : Informal
AgentAlertTime : 40
RoutingMethod : Attendant
DistributionGroupAddress : 
OwnerPool : SBG-POOL01.domain.net
AgentsByUri : {sip:bi@publicdomain.com, sip:car@publicdomain.com, sip:she@publicdomain.com, sip:pa@publicdomain.com...}
</code></pre>
 
 
The second command's output is going to be this 
 

<pre><code class="code-100 nolinks" id="code-20-42834622-2">PS C:\&gt; (Get-CsRgsAgentGroup | select -first 1 -expa AgentsByUri) -replace '[a-z]', '*' &gt;1.txt
Get-CsRgsAgentGroup : The pipeline has been stopped.
At line:1 char:2
+ (Get-CsRgsAgentGroup | select -first 1 -expa AgentsByUri) -replace '[a-z]', '*' ...
+ ~~~~~~~~~~~~~~~~~~~
 + CategoryInfo : NotSpecified: (:) [Get-CsRgsAgentGroup], PipelineStoppedException
 + FullyQualifiedErrorId : Microsoft.Rtc.Rgs.Management.GetOcsRgAgentGroupCmdlet




AbsolutePath : bi@publicdomain.com
AbsoluteUri : sip:bi@publicdomain.com
LocalPath : bi@publicdomain.com
Authority : 
HostNameType : Unknown
IsDefaultPort : True
IsFile : False
IsLoopback : False
PathAndQuery : bi@publicdomain.com
Segments : {bi@publicdomain.com}
IsUnc : False
Host : 
Port : -1
Query : 
Fragment : 
Scheme : sip
OriginalString : sip:bi@publicdomain.com
DnsSafeHost : 
IdnHost : 
IsAbsoluteUri : True
UserEscaped : False
UserInfo : 

AbsolutePath : ca@publicdomain.com
AbsoluteUri : sip:ca@publicdomain.com
LocalPath : ca@publicdomain.com
Authority : 
HostNameType : Unknown
IsDefaultPort : True
IsFile : False
IsLoopback : False
PathAndQuery : ca@publicdomain.com
Segments : {ca@publicdomain.com}
IsUnc : False
Host : 
Port : -1
Query : 
Fragment : 
Scheme : sip
OriginalString : sip:ca@publicdomain.com
DnsSafeHost : 
IdnHost : 
IsAbsoluteUri : True
UserEscaped : False
UserInfo : 

AbsolutePath : sh@publicdomain.com
AbsoluteUri : sip:sh@publicdomain.com
LocalPath : sh@publicdomain.com
Authority : 
HostNameType : Unknown
IsDefaultPort : True
IsFile : False
IsLoopback : False
PathAndQuery : sh@publicdomain.com
Segments : {sh@publicdomain.com}
IsUnc : False
Host : 
Port : -1
Query : 
Fragment : 
Scheme : sip
OriginalString : sip:sh@publicdomain.com
DnsSafeHost : 
IdnHost : 
IsAbsoluteUri : True
UserEscaped : False
UserInfo : 

AbsolutePath : pa@publicdomain.com
AbsoluteUri : sip:pa@publicdomain.com
LocalPath : pa@publicdomain.com
Authority : 
HostNameType : Unknown
IsDefaultPort : True
IsFile : False
IsLoopback : False
PathAndQuery : pa@publicdomain.com
Segments : {pa@publicdomain.com}
IsUnc : False
Host : 
Port : -1
Query : 
Fragment : 
Scheme : sip
OriginalString : sip:pa@publicdomain.com
DnsSafeHost : 
IdnHost : 
IsAbsoluteUri : True
UserEscaped : False
UserInfo : 

AbsolutePath : be@publicdomain.com
AbsoluteUri : sip:be@publicdomain.com
LocalPath : be@publicdomain.com
Authority : 
HostNameType : Unknown
IsDefaultPort : True
IsFile : False
IsLoopback : False
PathAndQuery : be@publicdomain.com
Segments : {be@publicdomain.com}
IsUnc : False
Host : 
Port : -1
Query : 
Fragment : 
Scheme : sip
OriginalString : sip:be@publicdomain.com
DnsSafeHost : 
IdnHost : 
IsAbsoluteUri : True
UserEscaped : False
UserInfo : 

AbsolutePath : nic@publicdomain.com
AbsoluteUri : sip:nic@publicdomain.com
LocalPath : nic@publicdomain.com
Authority : 
HostNameType : Unknown
IsDefaultPort : True
IsFile : False
IsLoopback : False
PathAndQuery : nic@publicdomain.com
Segments : {nic@publicdomain.com}
IsUnc : False
Host : 
Port : -1
Query : 
Fragment : 
Scheme : sip
OriginalString : sip:nic@publicdomain.com
DnsSafeHost : 
IdnHost : 
IsAbsoluteUri : True
UserEscaped : False
UserInfo : 
</code></pre>
</div>

Azure / Office 365 Integration engineer

Mohammed Hamada

<div>
Thank you so much, that worked great
</div>

<div>
<div class="content wysiwyg-content">
Dear Experts, 
 
I am trying to use powershell to clean a CSV file from certain values. The output of powershell is normally like this 
 
 
Name &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;$_.AgentsByUri &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
---- &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; -------------- &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
ResponseGroup1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {sip:user@domain.ca, sip:user2@domain.ca} 
 
I want to clear the csv file from the {sip:} And leave users with their uri only. So the output would be like the following 
 
Name &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;$_.AgentsByUri &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
---- &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; -------------- &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
ResponseGroup1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;user@domain.ca, user2@domain.ca 
 
I tried to do this with trim but didn't work properly.
</div>
</div>

Dear Experts,

I am trying to use powershell to clean a CSV file from certain values. The output of powershell is normally like this 


Name                                                                                                            $_.AgentsByUri                                                                                                                  
----                                                                                                                             --------------                                                                                                                  
ResponseGroup1                                                                                         {sip:user@domain.ca, sip:user2@domain.ca} 

I want to clear the csv file from the {sip:} And leave users with their uri only. So the output would be like the following

Name                                                                                                            $_.AgentsByUri                                                                                                                  
----                                                                                                                             --------------                                                                                                                  
ResponseGroup1                                                                                        user@domain.ca, user2@domain.ca

I tried to do this with trim but didn't work properly.

Cleaning CSV file with powershell script

Windows PowerShell is a task automation and configuration management framework from Microsoft, consisting of a command-line shell and associated scripting language built on the .NET Framework. PowerShell provides full access to the Component Object Model (COM) and Windows Management Instrumentation (WMI), enabling administrators to perform administrative tasks on both local and remote Windows systems as well as WS-Management and Common Information Model (CIM) enabling management of remote Linux systems and network devices.

Powershell

Microsoft Lync Server (renamed Skype for Business Server in 2015) is a real-time communications server software that provides infrastructure for enterprise instant messaging, presence, VoIP, ad hoc and structured conferences (audio, video, and web), and PSTN connectivity through a third-party gateway or SIP trunk. These features are available within and between organizations, and with external users on the public internet or standard phones (on bpth PSTN and SIP trunking).

Microsoft Lync Server

Exchange is the server side of a collaborative application product that is part of the Microsoft Server infrastructure. Exchange's major features include email, calendaring, contacts and tasks, support for mobile and web-based access to information, and support for data storage.