Hi all,
I'm trying to do the most simple of things, so I can start writing in
Powershell instead of vbscript, but can't find a way to do it...
Basically I'm processing a large input stream (30k+ users from a remote
data source) of text, in two columns of Variable Name and Variable Data,
starting with a Unique ID, followed by 3 lines related to that ID, then
it repeats for the next user, e.g
ID User1
FN John
SN Thomas
ID User2
FN Rick
SN Rubin
.
Etc
What I want to do is group each variable per Unique ID and process them.
So I get something like
ID(1) = "User1"
FN(1) = "John"
SN(1) = "Thomas"
Simple, but as my columns don't have column headings, I can't find the
Powershell command to separate the Variable Name and Variable Data
string into variables I can use. This seems to be the universal example
of basic manipulation of columns, but the get-process command gives
column headers, which I don't have
$tring = get-process |select-object Name,VM -first 10
"{0} is the second process, VM is {1}" -f
$tring[1].Name,$tring[1].VM
So I'm looking to isolate the Variables. I've tried using the
formatstring command, but I can't get it to return the entire variable,
only 1 character of text
$test = "ABCD EFGH"
$first = "{0}" -f $test[0]
echo $first
A
I need the whole word assign so, I'd like to do
$test = "ABCD EFGH"
$first = "{0}" -f $test[<first word>]
$second = ""{0}" -f $test[<second word>]
echo $first
John
echo $second
Thomas
Also these variables are of variable length, so
$first = "{0}" -f $test[1-4]
Wouldn't work. Help!?!
Many thanks,
Neal
P.S. My goal is to write something that will process the entire dataset
in Powershell. I can write the lot to a text file and do whatever I like
in vbscript, that's easy for me, but I'm trying to use Powershell in a
more intelligent way so that I don't have to store and process the data
locally. It may be that this 'online' method is too slow anyway, but I
want to try...
___________________________________________________________
Neal Palmer
Senior Technical Support Officer
Systems and Communications Services
Information Services Division
UWIC, Cardiff, Wales, CF5 2YB
UWIC Mysite
<http://mysites.staff.uwic.ac.uk/Person.aspx?accountname=CAMPUS\cc0078>
___________________________________________________________
P SAVE PAPER - Please do not print this e-mail unless absolutely
necessary
~ Finally, powerful endpoint security that ISN'T a resource hog! ~
~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
---
To manage subscriptions click here:
http://lyris.sunbelt-software.com/read/my_forums/
or send an email to listmana...@lyris.sunbeltsoftware.com
with the body: unsubscribe ntsysadmin<<image001.gif>>
