Is there same cmdlet for excel left right mid trim function ?
-
Friday, December 14, 2012 8:24 AMIs there same cmdlet for excel left right mid trim function ?
All Replies
-
Friday, December 14, 2012 8:57 AM
Hi,
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]
Regards
Dan -
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 '
$s.Trim()
$s.TrimEnd()
$s.TrimStart()
$s.SubString(4,3)
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
Thank you.
I will start to learn.

