Hey PowerShell Guy !, How Can I Remove Extraneous Spaces From Fields in a Text File?
A little one before the, 2008 Winter Scripting Games
The PowerShell version of the Hey Scripting guy VBScript version : How Can I Remove Extraneous Spaces From Fields in a Text File?
(gc c:\scripts\test.txt) -replace ' {2,}',''
PoSH> gc c:\scripts\test.txt
Emailaddr |Firstname |Lastname
"kmyer@fabrikam.com "|"Ken "|"Myer "|
"aabudayah@fabrikam.com "|"Ahmad "|"Abu Dayah "|
"htandersen@fabrikam.com "|"Henriette Thaulow "|"Andersen"|
PoSH> (gc c:\scripts\test.txt) -replace ' {2,}',''
Emailaddr|Firstname|Lastname
"kmyer@fabrikam.com"|"Ken"|"Myer"|
"aabudayah@fabrikam.com"|"Ahmad"|"Abu Dayah"|
"htandersen@fabrikam.com"|"Henriette Thaulow"|"Andersen"|
PoSH> (gc c:\scripts\test.txt) -replace ' {2,}','' | sc c:\scripts\test.txt
PoSH> gc c:\scripts\test.txt
Emailaddr|Firstname|Lastname
"kmyer@fabrikam.com"|"Ken"|"Myer"|
"aabudayah@fabrikam.com"|"Ahmad"|"Abu Dayah"|
"htandersen@fabrikam.com"|"Henriette Thaulow"|"Andersen"|
PoSH>
Note
- GC is an alias for Get-Content
- SC is an alias for Set-Content
And as we can see above, if we want to save back the result :
(gc c:\scripts\test.txt) -replace ' {2,}','' | sc c:\scripts\test.txt
another one to easy to resist ;-)
Enjoy,
Greetings /\/\o\/\/