Is there same cmdlet for excel left right mid trim function ?

All Replies

• Friday, December 14, 2012 8:57 AM

   

   
  

  0

  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

  • Reply
  • Quote

   
• Friday, December 14, 2012 9:09 AM

   

   
  

  0

  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
  •  
  • Reply
  • Quote

   
• Friday, December 14, 2012 4:44 PM

   

   
  

  0

  Thank you.

  I will start to learn.

  • Reply
  • Quote