Hi All,

I'm trying to find a way to replace all the dots with commas in this string that are not part of the date or time at the beginning

01/29/2010 9:32:22.196 168 99.99999234234 99.34234324234234 95.23123324234324 47.321999230984

what I want is a line that looks like this

01/29/2010 9:32:22.196 168 99,99999234234 99,34234324234234 95,23123324234324 47,321999230984

something like this \s\d+(\.)\d+ will match the number but if I then need to just do the replace on the group in the () and i cannot figure out how todo this.

Hope that makes sense

JonG

Try this:

$before = "01/29/2010 9:32:22.196 168 99.99999234234 99.34234324234234 95.23123324234324 47.321999230984"

$regex = '(?< date >\d{1,2}/\d{1,2}/\d{1,4})\s(?< time >\d{1,2}:\d{1,2}:\d{1,2}\.\d+)\s(?< someData >.*)' # remove the spaces in the angle brackets

if ($before -match $regex)
{
    $after = $Matches["date"] + ' ' + $Matches["time"] + ' ' + ($Matches["someData"] -replace '\.', ',')
}

$after