tags:

views:

12

answers:

0
Q: 

Help with Script for Extracting Specific Data from String

Below is a list of data in a single file. I'd like to run this in Powershell. LESCAR85 07/31/10 1700678991 / 70039536 $35.00
SQUADCT8 07/31/10 1698125739 / 70039539 $35.00
RINGFIEL 07/29/10 11041563 / 70039639 $35.00

The 8 digit number and then the dollar amount at the end I would like convert to csv so that I can use that in an excel file. The first set of longer numbers is not always the same which changes the number of spaces between the 8 digit sequence I need and the dollar amount.

Thanks!

related questions

Determine What Version of PowerShell is Installed?
Determine Users Accessing a Shared Folder Using PowerShell
PowerShell Get-Item question
Building a Snap-in Targeting PowerShell V1 and PowerShell V2
Powershell, trying to output only the path and lastwritetime on directories
How can I change the IP address of all sites in IIS6 using powershell 1.0?
Locate Compressed files on servers
Unable to obtain physical memory informatin using powershell
FTP error in powershell
PowerShell 1 is not capturing batch file output with tee
Identify the PID of a Executing Batch File in Powershell
Power Shell Installation Vista error
Capturing Powershell output in C# after Pipeline.Invoke throws
Can I use PowerShell 1.0 to list processes along with their PIDs and Command Lines?
c# Powershell. Configure runspace using RunspaceConfiguration.Create
Ouput redirection/capturing issue with Powershell and Try-Catch and external EXE
PowerShell Script to automate data entry to OpenOffice Calc Spreadsheet
Powershell.exe running the script in cli, or a wrapper?
Powershell not loading profile when running through PSEXEC
Is it possible to have many pipelines for 1 runspace.
How to Remove ReadOnly Attribute on File Using PowerShell?
How can I find the source path of an executing script?
PowerShell: Performance of .NET methods calls
Using PowerShell with .NET 3.5 runtime/libraries
Powershell remoting with V1