Solved

# Removing Duplicate words from lines in a power shell

Posted on 2015-02-23
103 Views
Hi

I am trying to find away to remove Duplicate words from a text file using Powershell

Name1 PC1234 PC1234 start Tue 2/17 6:53
Name2 PC5678 PC5678 start Tue 2/17 7:51

What I would like is

Name1 PC1234 start Tue 2/17 6:53
Name2 PC5678 start Tue 2/17 7:51

I have managed to get it working using the following but I would like to be able to open a .txt file remove the duplicate on all lines and right the content back to a new file.

$text= "Name1 PC1234 PC1234 start Tue 2/17 6:53"$text.Length
$text.remove(14)  Thank you of your help 0 Question by:Si Walton [X] ###### Welcome to Experts Exchange Add your voice to the tech community where 5M+ people just like you are talking about what matters. • Help others & share knowledge • Earn cash & points • Learn & ask questions 5 Comments LVL 53 Expert Comment ID: 40626292 Might not be a solution that your looking for, but the easiest way to accomplish this is in Excel and using the remove duplicate button. Will. 0 LVL 84 Accepted Solution oBdA earned 250 total points ID: 40626329 So the third column is always a copy of the second? This will remove the third column: Get-Content C:\Temp\in.txt | % {$_.Split(" ")[0..1+3..($_.Length -1)] -join " "} | Set-Content C:\Temp\out.txt  0 LVL 1 Author Comment ID: 40627722 Hi oBda Almost there and I understand the$_.Split

How would I be able to get the code to ignore the 1st line in the text file.

Keep this text
Name1 PC1234 PC1234 start Tue 2/17 6:53
Name2 PC5678 PC5678 start Tue 2/17 7:51

Thank you

Si
0

LVL 70

Assisted Solution

Qlemo earned 250 total points
ID: 40627914
$( Get-Content C:\Temp\in.txt | select -First 1 Get-Content C:\Temp\in.txt | select -Skip 1 | % {$_.Split(" ")[0..1+3..(\$_.Length -1)] -join " "}
) | Set-Content C:\Temp\out.txt

0

LVL 1

Author Closing Comment

ID: 40627936
Hi oBda and Qlemo

Thank you the solutions worked perfectly

Si
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Synchronize a new Active Directory domain with an existing Office 365 tenant
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…
Why Skyport?
###### Suggested Courses
Course of the Month5 days, 7 hours left to enroll