Parsing a test file

I need to parse a simple text file, get-content doesn't seem to provide a
straightforward way.

Consider contents of server.txt as :

ServerA,5
ServerB,6
ServerC,12


If I do FOR /F "tokens=* delims=," %I in (server.txt) do echo %I has a
value of %J
ServerA has a value of 5
ServerB has a value of 6
ServerC has a value of 12

So the variable %I is equal to the first part and %J equal to the second.
How do I accomplish this in PowerShell???

--
Paul Hinsberg

cat test.txt | %{Write-Host $_.Split(",")[0] "has value" $_.Split(",")[1]}

--
Brandon Shell
---------------
Stop by my blog some time
Blog: http://www.bsonposh.com/
PSH Scripts Project: www.codeplex.com/psobject
--------------------------------------

"Paul Hinsberg" <paulhins(antispam)@comcast.net> wrote in message
newsE381330-2947-4518-AEC0-2AE05A4DFFCD@microsoft.com...
>I need to parse a simple text file, get-content doesn't seem to provide a
> straightforward way.
>
> Consider contents of server.txt as :
>
> ServerA,5
> ServerB,6
> ServerC,12
>
>
> If I do FOR /F "tokens=* delims=," %I in (server.txt) do echo %I has a
> value of %J
> ServerA has a value of 5
> ServerB has a value of 6
> ServerC has a value of 12
>
> So the variable %I is equal to the first part and %J equal to the second.
> How do I accomplish this in PowerShell???
>
> --
> Paul Hinsberg

This one-liner i have come up with is similiar to the batch scripting
version in concept;
This one should look fairly straight-forward to read(I have also
refrained myself from using aliases )

# retrieve content of "servers.txt"
# For each line in "servers.txt", split a string with a delimiter ","
# and assign splitted strings to $name and $value for print out

[^_^]PS[88]>(get-content servers.txt) | foreach { $name, $value =
$_.Split(","); "{0} has a value of {1}" -f $name, $value }
ServerA has a value of 5
ServerB has a value of 6
ServerC has a value of 12

"Sung M Kim" <DontBotherMeWithSpam@gmail.com> wrote in message
news:1170964488.426864.160060@k78g2000cwa.googlegroups.com...
> This one-liner i have come up with is similiar to the batch scripting
> version in concept;
> This one should look fairly straight-forward to read(I have also
> refrained myself from using aliases )
>
> # retrieve content of "servers.txt"
> # For each line in "servers.txt", split a string with a delimiter ","
> # and assign splitted strings to $name and $value for print out
>
> [^_^]PS[88]>(get-content servers.txt) | foreach { $name, $value =
> $_.Split(","); "{0} has a value of {1}" -f $name, $value }
> ServerA has a value of 5
> ServerB has a value of 6
> ServerC has a value of 12

Yet another way is:

switch -regex -file foo.txt { '(.*),(.*)' { $matches[1] + " has value of " +
$matches[2] }}

--
Keith

Contest time... who can make it the shortest!
--
Brandon Shell
---------------
Stop by my blog some time
Blog: http://www.bsonposh.com/
PSH Scripts Project: www.codeplex.com/psobject
--------------------------------------

"Keith Hill" <r_keith_hill@mailhot.nospamIdotcom> wrote in message
newsE417379-56EE-4C1E-9DEE-D3806570B155@microsoft.com...
>
> "Sung M Kim" <DontBotherMeWithSpam@gmail.com> wrote in message
> news:1170964488.426864.160060@k78g2000cwa.googlegroups.com...
>> This one-liner i have come up with is similiar to the batch scripting
>> version in concept;
>> This one should look fairly straight-forward to read(I have also
>> refrained myself from using aliases )
>>
>> # retrieve content of "servers.txt"
>> # For each line in "servers.txt", split a string with a delimiter ","
>> # and assign splitted strings to $name and $value for print out
>>
>> [^_^]PS[88]>(get-content servers.txt) | foreach { $name, $value =
>> $_.Split(","); "{0} has a value of {1}" -f $name, $value }
>> ServerA has a value of 5
>> ServerB has a value of 6
>> ServerC has a value of 12
>
> Yet another way is:
>
> switch -regex -file foo.txt { '(.*),(.*)' { $matches[1] + " has value of "
> + $matches[2] }}
>
> --
> Keith
>

If you its possible to add a header line you could use import-csv.

PS>type temp.txt
Server,Value
ServerA,5
ServerB,6
ServerC,12
PS>import-csv temp.txt

Server Value
------ -----
ServerA 5
ServerB 6
ServerC 12


PS>


"Sung M Kim" <DontBotherMeWithSpam@gmail.com> wrote in message
news:1170964488.426864.160060@k78g2000cwa.googlegroups.com...
> This one-liner i have come up with is similiar to the batch scripting
> version in concept;
> This one should look fairly straight-forward to read(I have also
> refrained myself from using aliases )
>
> # retrieve content of "servers.txt"
> # For each line in "servers.txt", split a string with a delimiter ","
> # and assign splitted strings to $name and $value for print out
>
> [^_^]PS[88]>(get-content servers.txt) | foreach { $name, $value =
> $_.Split(","); "{0} has a value of {1}" -f $name, $value }
> ServerA has a value of 5
> ServerB has a value of 6
> ServerC has a value of 12
>

> Contest time... who can make it the shortest!

ipcsv list.csv

;-)

add headers like this :

Name,Value
ServerA,5
ServerB,6
ServerC,12

PoSH> sc list.csv @'
>> Name,Value
>> ServerA,5
>> ServerB,6
>> ServerC,12
>> '@
>>
PoSH> ipcsv list.csv

Name Value
---- -----
ServerA 5
ServerB 6
ServerC 12

Greetings /\/\o\/\/

"Brandon Shell" <tshell.mask@gmail.com> wrote in message
news:OqUH247SHHA.5012@TK2MSFTNGP04.phx.gbl...
> Contest time... who can make it the shortest!
> --
> Brandon Shell
> ---------------
> Stop by my blog some time
> Blog: http://www.bsonposh.com/
> PSH Scripts Project: www.codeplex.com/psobject
> --------------------------------------
>
> "Keith Hill" <r_keith_hill@mailhot.nospamIdotcom> wrote in message
> newsE417379-56EE-4C1E-9DEE-D3806570B155@microsoft.com...
>>
>> "Sung M Kim" <DontBotherMeWithSpam@gmail.com> wrote in message
>> news:1170964488.426864.160060@k78g2000cwa.googlegroups.com...
>>> This one-liner i have come up with is similiar to the batch scripting
>>> version in concept;
>>> This one should look fairly straight-forward to read(I have also
>>> refrained myself from using aliases )
>>>
>>> # retrieve content of "servers.txt"
>>> # For each line in "servers.txt", split a string with a delimiter ","
>>> # and assign splitted strings to $name and $value for print out
>>>
>>> [^_^]PS[88]>(get-content servers.txt) | foreach { $name, $value =
>>> $_.Split(","); "{0} has a value of {1}" -f $name, $value }
>>> ServerA has a value of 5
>>> ServerB has a value of 6
>>> ServerC has a value of 12
>>
>> Yet another way is:
>>
>> switch -regex -file foo.txt { '(.*),(.*)' { $matches[1] + " has value of
>> " + $matches[2] }}
>>
>> --
>> Keith
>>
>

Sooo many squiggly brackets, so little time...

The import-csv looks cool, but how would you assign each value in the
perspective column to a variable? I am afraid the judges have ruled that
this is one the parameters for the contest. : )

--
Paul Hinsberg


"Marcel J. Ortiz [MSFT]" wrote:

> If you its possible to add a header line you could use import-csv.
>
> PS>type temp.txt
> Server,Value
> ServerA,5
> ServerB,6
> ServerC,12
> PS>import-csv temp.txt
>
> Server Value
> ------ -----
> ServerA 5
> ServerB 6
> ServerC 12
>
>
> PS>
>
>
> "Sung M Kim" <DontBotherMeWithSpam@gmail.com> wrote in message
> news:1170964488.426864.160060@k78g2000cwa.googlegroups.com...
> > This one-liner i have come up with is similiar to the batch scripting
> > version in concept;
> > This one should look fairly straight-forward to read(I have also
> > refrained myself from using aliases )
> >
> > # retrieve content of "servers.txt"
> > # For each line in "servers.txt", split a string with a delimiter ","
> > # and assign splitted strings to $name and $value for print out
> >
> > [^_^]PS[88]>(get-content servers.txt) | foreach { $name, $value =
> > $_.Split(","); "{0} has a value of {1}" -f $name, $value }
> > ServerA has a value of 5
> > ServerB has a value of 6
> > ServerC has a value of 12
> >
>
>
>

It already is ;-)
the $_ variable

PoSH> ipcsv list.csv |% {"$($_.name) = ";$_.value}
ServerA =
5
ServerB =
6
ServerC =
12

Greetings /\/\o\/\/

"Paul Hinsberg" <paulhins(antispam)@comcast.net> wrote in message
news:A183EB9F-68D6-4C31-98D6-65EBCA1D834E@microsoft.com...
> Sooo many squiggly brackets, so little time...
>
> The import-csv looks cool, but how would you assign each value in the
> perspective column to a variable? I am afraid the judges have ruled that
> this is one the parameters for the contest. : )
>
> --
> Paul Hinsberg
>
>
> "Marcel J. Ortiz [MSFT]" wrote:
>
>> If you its possible to add a header line you could use import-csv.
>>
>> PS>type temp.txt
>> Server,Value
>> ServerA,5
>> ServerB,6
>> ServerC,12
>> PS>import-csv temp.txt
>>
>> Server Value
>> ------ -----
>> ServerA 5
>> ServerB 6
>> ServerC 12
>>
>>
>> PS>
>>
>>
>> "Sung M Kim" <DontBotherMeWithSpam@gmail.com> wrote in message
>> news:1170964488.426864.160060@k78g2000cwa.googlegroups.com...
>> > This one-liner i have come up with is similiar to the batch scripting
>> > version in concept;
>> > This one should look fairly straight-forward to read(I have also
>> > refrained myself from using aliases )
>> >
>> > # retrieve content of "servers.txt"
>> > # For each line in "servers.txt", split a string with a delimiter ","
>> > # and assign splitted strings to $name and $value for print out
>> >
>> > [^_^]PS[88]>(get-content servers.txt) | foreach { $name, $value =
>> > $_.Split(","); "{0} has a value of {1}" -f $name, $value }
>> > ServerA has a value of 5
>> > ServerB has a value of 6
>> > ServerC has a value of 12
>> >
>>
>>
>>

Yeah I too was wondering when there is CSV file management made so easy why
don't we use them and what it requries to create CSV file.

Header makes life really easy.

http://Techstarts.blogspot.com

"/\/\o\/\/ [MVP]" <mow001@hotmail.NoSpam> wrote in message
news:268FEA86-7405-4936-AAD2-DEEC426C6F6C@microsoft.com...
>> Contest time... who can make it the shortest!
>
> ipcsv list.csv
>
> ;-)
>
> add headers like this :
>
> Name,Value
> ServerA,5
> ServerB,6
> ServerC,12
>
> PoSH> sc list.csv @'
>>> Name,Value
>>> ServerA,5
>>> ServerB,6
>>> ServerC,12
>>> '@
>>>
> PoSH> ipcsv list.csv
>
> Name
> Value
> ---- -----
> ServerA 5
> ServerB 6
> ServerC 12
>
> Greetings /\/\o\/\/
>
> "Brandon Shell" <tshell.mask@gmail.com> wrote in message
> news:OqUH247SHHA.5012@TK2MSFTNGP04.phx.gbl...
>> Contest time... who can make it the shortest!
>> --
>> Brandon Shell
>> ---------------
>> Stop by my blog some time
>> Blog: http://www.bsonposh.com/
>> PSH Scripts Project: www.codeplex.com/psobject
>> --------------------------------------
>>
>> "Keith Hill" <r_keith_hill@mailhot.nospamIdotcom> wrote in message
>> newsE417379-56EE-4C1E-9DEE-D3806570B155@microsoft.com...
>>>
>>> "Sung M Kim" <DontBotherMeWithSpam@gmail.com> wrote in message
>>> news:1170964488.426864.160060@k78g2000cwa.googlegroups.com...
>>>> This one-liner i have come up with is similiar to the batch scripting
>>>> version in concept;
>>>> This one should look fairly straight-forward to read(I have also
>>>> refrained myself from using aliases )
>>>>
>>>> # retrieve content of "servers.txt"
>>>> # For each line in "servers.txt", split a string with a delimiter ","
>>>> # and assign splitted strings to $name and $value for print out
>>>>
>>>> [^_^]PS[88]>(get-content servers.txt) | foreach { $name, $value =
>>>> $_.Split(","); "{0} has a value of {1}" -f $name, $value }
>>>> ServerA has a value of 5
>>>> ServerB has a value of 6
>>>> ServerC has a value of 12
>>>
>>> Yet another way is:
>>>
>>> switch -regex -file foo.txt { '(.*),(.*)' { $matches[1] + " has value of
>>> " + $matches[2] }}
>>>
>>> --
>>> Keith
>>>
>>
>