Friday, December 14, 2012 8:24 AMIs there same cmdlet for excel left right mid trim function ?
Friday, December 14, 2012 8:57 AM
Excel can only be edited via the com object.
--> look Here: http://theolddogscriptingblog.wordpress.com/2010/06/01/powershell-excel-cookbook-ver-2/
Other option is to save the excel as CSV and import it to powershell via
$csv = import-csv [path]
Friday, December 14, 2012 9:09 AM
Is there same cmdlet for excel left right mid trim function ?
Strings in PowerShell can be trimmed left/right and mid.
$s=' Hello World '
All things ae possible and better. Get yourself a training book and start learning.
- Marked As Answer by Bill_StewartMicrosoft Community Contributor, Moderator Monday, December 31, 2012 7:21 PM
Friday, December 14, 2012 4:44 PM
I will start to learn.