Advanced Windows PowerShell Scripting Video Training

Advanced Windows PowerShell Scripting Video Training
Advanced Windows PowerShell Scripting Video Training

Friday, August 28, 2015

String Manipulation–Custom Problem

I just received an email that an IT Pro out on the internet posted a comment to my article on How to specify the number of decimal places in PowerShell Output. This was a bit more of a detailed response so I’m posting it as a blog article.

His issue was that we is presented with a string of numbers. The string contains sets of nine numbers.  The first 7 represented dollars and the last 2 of each set represented cents.  He needed a total.  We just finished talking about string manipulation in class so I went at it.  Here you go Matt!

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

# Starting Data

$Data = "000000025000001000000283711000025000037000054000000017"

 

# Determine the number of records in the string.

$MaxItems = $Data.length/9

 

$Total = 0

# Loop the number of records.

For($X=0; $X -lt $MaxItems; $X++)

{

    # Use the SubString method of System.String

    # to extract 9 characters at a time.

    $D = $Data.Substring($X*9,9)

 

 

    # use the first 7 characters as the dollar value.

    [int]$Dollars = $D.Remove(7,2)

 

    # Use the last 2 characters as the cents value.

    [int]$Cents = $D.Remove(0,7)

 

    # Add the 2 to get the total.

    [Single]$Total += $dollars + $cents/100

   

    # Output the object to the pipeline.

    $Obj = New-Object -TypeName PSObject -Property @{

        Dollars = $Dollars

        Cents = $Cents

        }

 

    Write-Output $Obj

 

}

 

# Write the Total.

Write-Output $Total 

 

No comments: