I have imported a csv using import-csv

$clcode = import-csv $csvlocation | select clcode



$clcode results are a list of 6 digit numbers, for the next part of the
script I need to add ',' to the end of the 6 digits, I have messed around
with different methods and have been unable to figure out how to do it,
easily.

Please help
Neil

On Dec 28, 8:13 am, NeilOz <Nei...@xxxxxx> wrote:

> I have imported a csv using import-csv
>
> $clcode = import-csv $csvlocation | select clcode
>
> $clcode results are a list of 6 digit numbers, for the next part of the
> script I need to add ',' to the end of the 6 digits, I have messed around
> with different methods and have been unable to figure out how to do it,
> easily.
>
> Please help
> Neil

Neil,

This should do the trick:

for ( $i = 0; $i -lt $clcode.Length; $i++ )
{
$clcode[ $i ] += ","
}

Jeff

import-csv creates a collection of objects with properties generated
from your columns in the csv.

so here i presume clcode is the name of that column.. then you could do
something like this

import-csv $csvlocation | foreach { $_.clcode += ',' }


NeilOz wrote:

> I have imported a csv using import-csv
>
> $clcode = import-csv $csvlocation | select clcode
>
> $clcode results are a list of 6 digit numbers, for the next part of the
> script I need to add ',' to the end of the 6 digits, I have messed around
> with different methods and have been unable to figure out how to do it,
> easily.
>
> Please help
> Neil

"NeilOz" <NeilOz@xxxxxx> wrote in message
news:64A62FA8-4C54-49AC-9EEC-993ABB38D334@xxxxxx

> I have imported a csv using import-csv
>
> $clcode = import-csv $csvlocation | select clcode
>
> $clcode results are a list of 6 digit numbers, for the next part of the
> script I need to add ',' to the end of the 6 digits, I have messed around
> with different methods and have been unable to figure out how to do it,
> easily.

Try this:

$clcode = import-csv $csvlocation | select clcode | foreach
{"$($_.clcode),"}

This just uses string interpolation to convert the number into a string
followed by the comma.

--
Keith