
The rabbits wander aimlessly around the backyard vainly seeking a single green blade of grass for a meal. The birds sit in the shade pleading for a breeze. The dragonflies cannot fly because of the high humidity that saturates their thin wings, making them hang limply like a kite left outside during a spring shower. It is so hot and steamy outside that the crickets are hibernating. It is a lot of stress and I would love to automate it using Windows PowerShell. If someone goes on vacation, we have to train a replacement. The problem is that right now this is a time-consuming manual process.

In the past, when we tried to automate the downloading and updating process, there were several “incidents.” As a result, our management is skittish about anything related to these applications. Needless to say, this file is mission critical for us. A back office application automatically sets our quarterly price and volume discount points based upon the information from the g/l app.

We use the updated commodity pricing to determine our base cost for profit and loss in our general ledger application (g/l app). This file contains updated prices for commodities used in our manufacturing operation. I have a file that we need to download each day. Hey, Scripting Guy! Is it possible to use Windows PowerShell to groom a text file by deleting extra returns and line feeds it may contain? Here is the deal.
