Skip to main content

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 

 

Comments

Popular posts from this blog

Adding a Comment to a GPO with PowerShell

As I'm writing this article, I'm also writing a customization for a PowerShell course I'm teaching next week in Phoenix.  This customization deals with Group Policy and PowerShell.  For those of you who attend my classes may already know this, but I sit their and try to ask the questions to myself that others may ask as I present the material.  I finished up my customization a few hours ago and then I realized that I did not add in how to put a comment on a GPO.  This is a feature that many Group Policy Administrators may not be aware of. This past summer I attended a presentation at TechEd on Group Policy.  One organization in the crowd had over 5,000 Group Policies.  In an environment like that, the comment section can be priceless.  I always like to write in the comment section why I created the policy so I know its purpose next week after I've completed 50 other tasks and can't remember what I did 5 minutes ago. In the Group Policy module for PowerShell V3, th

Return duplicate values from a collection with PowerShell

If you have a collection of objects and you want to remove any duplicate items, it is fairly simple. # Create a collection with duplicate values $Set1 = 1 , 1 , 2 , 2 , 3 , 4 , 5 , 6 , 7 , 1 , 2   # Remove the duplicate values. $Set1 | Select-Object -Unique 1 2 3 4 5 6 7 What if you want only the duplicate values and nothing else? # Create a collection with duplicate values $Set1 = 1 , 1 , 2 , 2 , 3 , 4 , 5 , 6 , 7 , 1 , 2   #Create a second collection with duplicate values removed. $Set2 = $Set1 | Select-Object -Unique   # Return only the duplicate values. ( Compare-Object -ReferenceObject $Set2 -DifferenceObject $Set1 ) . InputObject | Select-Object – Unique 1 2 This works with objects as well as numbers.  The first command creates a collection with 2 duplicates of both 1 and 2.   The second command creates another collection with the duplicates filtered out.  The Compare-Object cmdlet will first find items that are diffe

How to list all the AD LDS instances on a server

AD LDS allows you to provide directory services to applications that are free of the confines of Active Directory.  To list all the AD LDS instances on a server, follow this procedure: Log into the server in question Open a command prompt. Type dsdbutil and press Enter Type List Instances and press Enter . You will receive a list of the instance name, both the LDAP and SSL port numbers, the location of the database, and its status.