How to use substring when using powershell select-object

Question

I'm wondering if there is a way to use do a substring when using powershell's select-object cmdlet

Here is an example of what i'm trying to do

$sapFile = "C:\MyFile*.XML"

# Get the newest xml file
$newestFile = Get-ChildItem -Path $sapFile | Sort CreationTime | Select -Last 1

# get the contents of the xml file
[XML]$sapContent = Get-Content -Path $newestFile.FullName

$sapContent.DATA.CP | Select -Property CP_NO,MEN.Substring(0,4)

This however doesn't work.

Thanks

TheMadTechnician · Accepted Answer · 2017-03-31 20:37:09Z

9

You can create a property on the fly using Select that has a calculated value by using a hashtable. In the following example I select the 'CP_NO' property, and create the 'MENSubString' property with a hashtable.

Select -Property CP_NO,@{label='MENSubString';expression={$_.MEN.Substring(0,4)}}

Label can be shortened to just 'l' and Expression can be shortened to just 'e', which would look like:

Select -Property CP_NO,@{l='MENSubString';e={$_.MEN.Substring(0,4)}}

answered Mar 31, 2017 at 20:37

TheMadTechnician

36.5k3 gold badges48 silver badges63 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Esperento57 · Accepted Answer · 2017-04-01 07:53:19Z

1

other method :

$sapContent.DATA.CP | foreach {
       [pscustomobject]@{
        CP_NO=$_.CP_NO
        PartOfMen=MEN.Substring(0,4)           
       }
      }

answered Apr 1, 2017 at 7:53

Esperento57

17.6k6 gold badges42 silver badges47 bronze badges

Collectives™ on Stack Overflow

How to use substring when using powershell select-object

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related