Windows Vista Forums
Vista Forums Home Join Vista Forums Windows 7 Forum Vista Tutorials Tags
Welcome to Windows Vista Forums. Our forum is dedicated to helping you find solutions with any problems, errors or issues you are experiencing with Windows Vista. The Vista forum also covers news and updates and has an extensive Windows Vista tutorial section that covers a wide range of tips and tricks.

Go Back   Vista Forums > Misc Newsgroups > PowerShell

Vista - end of line while processing a string token issue

Reply
 
Old 09-28-2007   #1 (permalink)
hectoritnt


 
 

end of line while processing a string token issue

I have this piece of code and can't figure out why it gives me this
error every time.

PS C:\Tools\Scripts> .\getusers.ps1
Encountered end of line while processing a string token.
At C:\Tools\Scripts\getusers.ps1:108 char:30
+ + $v30 + "," + $v31 + "," <<<< + $v32

Code;

$tempfile = "c:\temp.txt"

function Clean-Vars
{ $v1 = ""; $v2 = ""; $v3 = ""; $v4 = ""; $v5 = ""; $v6 = ""; $v7 =
""; $v8 = ""; $v9 = ""; $v10 = ""; $v11 = "";
$v12 = ""; $v13 = ""; $v14 = ""; $v15 = ""; $v16 = ""; $v17 = "";
$v18 = ""; $v19 = ""; $v20 = ""; $v21 = "";
$v22 = ""; $v23 = ""; $v24 = ""; $v25 = ""; $v26 = ""; $v27 = "";
$v28 = ""; $v29 = ""; $v30 = ""; $v31 = "";
$v32 = "" }

$allusers = get-adobject -domain mcd.pri -pagesize 500 -filter
"(&(mailNickname=*)(objectclass=user))
Clean-Vars
foreach ($one in $allusers) {
$usrs = $usrs + 1
$v1 = $one.objectclass[1]
$v2 = $one.cn
$v3 = $one.msExchHomeServerName.tostring()
$v3 = $v3.split('=')[5]
$v4 = $one.MDBOverquotalimit
$v5 = $one.mDBUseDefaults
$v6 = $one.mDBOverHardQuotaLimit
$v7 = $one.mailnickname
$v8 = $one.whencreated.tostring()
$v9 = $one.whenchanged.tostring()
$v10 = $one.sAMAccountName
$v11 = $one.givenname
$v12 = $one.sn
$v13 = '"' + $one.displayname + '"'
$v14 = $one.userprincipalname
$v15 = $one.mail
$v16 = $one.proxyaddresses
$v17 = $one.ou
$v18 = $one.msexchhidefromaddresslists
$v19 = $one.altrecipient
$v20 = $one.extensionattribute1
$v21 = $one.deliverandredirect
$v22 = $one.admindescription
$v24 = $one.telephoneNumber
$v25 = $one.pager
$v29 = '"' + $one.memberof + '"'
$v30 = $one.department
$v31 = $one.tittle
#
$vtot = $v1 + "," + $v2 + "," + $v3 + "," + $v4 + "," + $v5 + ","
+ $v6 + "," + $v7 + "," + $v8 + "," + $v9 + "," + $v10 + "," + $v11 +
"," `
+ $v12 + "," + $v13 + "," + $v14 + "," + $v15 + "," + $v16 + ","
+ $v17 + "," + $v18 + "," + $v19 + "," + $v20 + "," `
+ $v21 + "," + $v22 + "," + $v23 + "," + $v24 + "," + $v25 + ","
+ $v26 + "," + $v27 + "," + $v28 + "," + $v29 + "," `
+ $v30 + "," + $v31 + "," + $v32
add-content $tempfile $vtot
$vtot = ""
Clean-Vars
}

Any help will be appreciated.

Hector


My System SpecsSystem Spec
Old 09-28-2007   #2 (permalink)
Brandon Shell


 
 

Re: end of line while processing a string token issue

What is your end goal?
Why are you trying to clean-up the variables?
What are you expecting the output to look like?

"hectoritnt" <hectoritnt@xxxxxx> wrote in message
news:1190993581.745539.310020@xxxxxx
Quote:

>I have this piece of code and can't figure out why it gives me this
> error every time.
>
> PS C:\Tools\Scripts> .\getusers.ps1
> Encountered end of line while processing a string token.
> At C:\Tools\Scripts\getusers.ps1:108 char:30
> + + $v30 + "," + $v31 + "," <<<< + $v32
>
> Code;
>
> $tempfile = "c:\temp.txt"
>
> function Clean-Vars
> { $v1 = ""; $v2 = ""; $v3 = ""; $v4 = ""; $v5 = ""; $v6 = ""; $v7 =
> ""; $v8 = ""; $v9 = ""; $v10 = ""; $v11 = "";
> $v12 = ""; $v13 = ""; $v14 = ""; $v15 = ""; $v16 = ""; $v17 = "";
> $v18 = ""; $v19 = ""; $v20 = ""; $v21 = "";
> $v22 = ""; $v23 = ""; $v24 = ""; $v25 = ""; $v26 = ""; $v27 = "";
> $v28 = ""; $v29 = ""; $v30 = ""; $v31 = "";
> $v32 = "" }
>
> $allusers = get-adobject -domain mcd.pri -pagesize 500 -filter
> "(&(mailNickname=*)(objectclass=user))
> Clean-Vars
> foreach ($one in $allusers) {
> $usrs = $usrs + 1
> $v1 = $one.objectclass[1]
> $v2 = $one.cn
> $v3 = $one.msExchHomeServerName.tostring()
> $v3 = $v3.split('=')[5]
> $v4 = $one.MDBOverquotalimit
> $v5 = $one.mDBUseDefaults
> $v6 = $one.mDBOverHardQuotaLimit
> $v7 = $one.mailnickname
> $v8 = $one.whencreated.tostring()
> $v9 = $one.whenchanged.tostring()
> $v10 = $one.sAMAccountName
> $v11 = $one.givenname
> $v12 = $one.sn
> $v13 = '"' + $one.displayname + '"'
> $v14 = $one.userprincipalname
> $v15 = $one.mail
> $v16 = $one.proxyaddresses
> $v17 = $one.ou
> $v18 = $one.msexchhidefromaddresslists
> $v19 = $one.altrecipient
> $v20 = $one.extensionattribute1
> $v21 = $one.deliverandredirect
> $v22 = $one.admindescription
> $v24 = $one.telephoneNumber
> $v25 = $one.pager
> $v29 = '"' + $one.memberof + '"'
> $v30 = $one.department
> $v31 = $one.tittle
> #
> $vtot = $v1 + "," + $v2 + "," + $v3 + "," + $v4 + "," + $v5 + ","
> + $v6 + "," + $v7 + "," + $v8 + "," + $v9 + "," + $v10 + "," + $v11 +
> "," `
> + $v12 + "," + $v13 + "," + $v14 + "," + $v15 + "," + $v16 + ","
> + $v17 + "," + $v18 + "," + $v19 + "," + $v20 + "," `
> + $v21 + "," + $v22 + "," + $v23 + "," + $v24 + "," + $v25 + ","
> + $v26 + "," + $v27 + "," + $v28 + "," + $v29 + "," `
> + $v30 + "," + $v31 + "," + $v32
> add-content $tempfile $vtot
> $vtot = ""
> Clean-Vars
> }
>
> Any help will be appreciated.
>
> Hector
>
My System SpecsSystem Spec
Old 09-28-2007   #3 (permalink)
Brandon Shell


 
 

Re: end of line while processing a string token issue

As a note... If you decide to stick with the cleanup option... there is much
better way IMO

function Clean-Vars{
Param($Filter)
get-ChildItem variable: | Where-Object{$_.Name -match $filter} |
remove-Variable -whatif
}

The filter in this case would be "^v\d" I would recommend using a variable
naming scheme that is more precise
like myTmpVarX then the filter would be "^myTmpVar\d"

"hectoritnt" <hectoritnt@xxxxxx> wrote in message
news:1190993581.745539.310020@xxxxxx
Quote:

>I have this piece of code and can't figure out why it gives me this
> error every time.
>
> PS C:\Tools\Scripts> .\getusers.ps1
> Encountered end of line while processing a string token.
> At C:\Tools\Scripts\getusers.ps1:108 char:30
> + + $v30 + "," + $v31 + "," <<<< + $v32
>
> Code;
>
> $tempfile = "c:\temp.txt"
>
> function Clean-Vars
> { $v1 = ""; $v2 = ""; $v3 = ""; $v4 = ""; $v5 = ""; $v6 = ""; $v7 =
> ""; $v8 = ""; $v9 = ""; $v10 = ""; $v11 = "";
> $v12 = ""; $v13 = ""; $v14 = ""; $v15 = ""; $v16 = ""; $v17 = "";
> $v18 = ""; $v19 = ""; $v20 = ""; $v21 = "";
> $v22 = ""; $v23 = ""; $v24 = ""; $v25 = ""; $v26 = ""; $v27 = "";
> $v28 = ""; $v29 = ""; $v30 = ""; $v31 = "";
> $v32 = "" }
>
> $allusers = get-adobject -domain mcd.pri -pagesize 500 -filter
> "(&(mailNickname=*)(objectclass=user))
> Clean-Vars
> foreach ($one in $allusers) {
> $usrs = $usrs + 1
> $v1 = $one.objectclass[1]
> $v2 = $one.cn
> $v3 = $one.msExchHomeServerName.tostring()
> $v3 = $v3.split('=')[5]
> $v4 = $one.MDBOverquotalimit
> $v5 = $one.mDBUseDefaults
> $v6 = $one.mDBOverHardQuotaLimit
> $v7 = $one.mailnickname
> $v8 = $one.whencreated.tostring()
> $v9 = $one.whenchanged.tostring()
> $v10 = $one.sAMAccountName
> $v11 = $one.givenname
> $v12 = $one.sn
> $v13 = '"' + $one.displayname + '"'
> $v14 = $one.userprincipalname
> $v15 = $one.mail
> $v16 = $one.proxyaddresses
> $v17 = $one.ou
> $v18 = $one.msexchhidefromaddresslists
> $v19 = $one.altrecipient
> $v20 = $one.extensionattribute1
> $v21 = $one.deliverandredirect
> $v22 = $one.admindescription
> $v24 = $one.telephoneNumber
> $v25 = $one.pager
> $v29 = '"' + $one.memberof + '"'
> $v30 = $one.department
> $v31 = $one.tittle
> #
> $vtot = $v1 + "," + $v2 + "," + $v3 + "," + $v4 + "," + $v5 + ","
> + $v6 + "," + $v7 + "," + $v8 + "," + $v9 + "," + $v10 + "," + $v11 +
> "," `
> + $v12 + "," + $v13 + "," + $v14 + "," + $v15 + "," + $v16 + ","
> + $v17 + "," + $v18 + "," + $v19 + "," + $v20 + "," `
> + $v21 + "," + $v22 + "," + $v23 + "," + $v24 + "," + $v25 + ","
> + $v26 + "," + $v27 + "," + $v28 + "," + $v29 + "," `
> + $v30 + "," + $v31 + "," + $v32
> add-content $tempfile $vtot
> $vtot = ""
> Clean-Vars
> }
>
> Any help will be appreciated.
>
> Hector
>
My System SpecsSystem Spec
Old 09-28-2007   #4 (permalink)
hectoritnt


 
 

Re: end of line while processing a string token issue

On Sep 28, 12:17 pm, "Brandon Shell" <tshell.m...@xxxxxx> wrote:
Quote:

> As a note... If you decide to stick with the cleanup option... there is much
> better way IMO
>
> function Clean-Vars{
> Param($Filter)
> get-ChildItem variable: | Where-Object{$_.Name -match $filter} |
> remove-Variable -whatif
>
> }
>
> The filter in this case would be "^v\d" I would recommend using a variable
> naming scheme that is more precise
> like myTmpVarX then the filter would be "^myTmpVar\d"
>
> "hectoritnt" <hectori...@xxxxxx> wrote in message
>
> news:1190993581.745539.310020@xxxxxx
>
Quote:

> >I have this piece of code and can't figure out why it gives me this
> > error every time.
>
Quote:

> > PS C:\Tools\Scripts> .\getusers.ps1
> > Encountered end of line while processing a string token.
> > At C:\Tools\Scripts\getusers.ps1:108 char:30
> > + + $v30 + "," + $v31 + "," <<<< + $v32
>
Quote:

> > Code;
>
Quote:

> > $tempfile = "c:\temp.txt"
>
Quote:

> > function Clean-Vars
> > { $v1 = ""; $v2 = ""; $v3 = ""; $v4 = ""; $v5 = ""; $v6 = ""; $v7 =
> > ""; $v8 = ""; $v9 = ""; $v10 = ""; $v11 = "";
> > $v12 = ""; $v13 = ""; $v14 = ""; $v15 = ""; $v16 = ""; $v17 = "";
> > $v18 = ""; $v19 = ""; $v20 = ""; $v21 = "";
> > $v22 = ""; $v23 = ""; $v24 = ""; $v25 = ""; $v26 = ""; $v27 = "";
> > $v28 = ""; $v29 = ""; $v30 = ""; $v31 = "";
> > $v32 = "" }
>
Quote:

> > $allusers = get-adobject -domain mcd.pri -pagesize 500 -filter
> > "(&(mailNickname=*)(objectclass=user))
> > Clean-Vars
> > foreach ($one in $allusers) {
> > $usrs = $usrs + 1
> > $v1 = $one.objectclass[1]
> > $v2 = $one.cn
> > $v3 = $one.msExchHomeServerName.tostring()
> > $v3 = $v3.split('=')[5]
> > $v4 = $one.MDBOverquotalimit
> > $v5 = $one.mDBUseDefaults
> > $v6 = $one.mDBOverHardQuotaLimit
> > $v7 = $one.mailnickname
> > $v8 = $one.whencreated.tostring()
> > $v9 = $one.whenchanged.tostring()
> > $v10 = $one.sAMAccountName
> > $v11 = $one.givenname
> > $v12 = $one.sn
> > $v13 = '"' + $one.displayname + '"'
> > $v14 = $one.userprincipalname
> > $v15 = $one.mail
> > $v16 = $one.proxyaddresses
> > $v17 = $one.ou
> > $v18 = $one.msexchhidefromaddresslists
> > $v19 = $one.altrecipient
> > $v20 = $one.extensionattribute1
> > $v21 = $one.deliverandredirect
> > $v22 = $one.admindescription
> > $v24 = $one.telephoneNumber
> > $v25 = $one.pager
> > $v29 = '"' + $one.memberof + '"'
> > $v30 = $one.department
> > $v31 = $one.tittle
> > #
> > $vtot = $v1 + "," + $v2 + "," + $v3 + "," + $v4 + "," + $v5 + ","
> > + $v6 + "," + $v7 + "," + $v8 + "," + $v9 + "," + $v10 + "," + $v11 +
> > "," `
> > + $v12 + "," + $v13 + "," + $v14 + "," + $v15 + "," + $v16 + ","
> > + $v17 + "," + $v18 + "," + $v19 + "," + $v20 + "," `
> > + $v21 + "," + $v22 + "," + $v23 + "," + $v24 + "," + $v25 + ","
> > + $v26 + "," + $v27 + "," + $v28 + "," + $v29 + "," `
> > + $v30 + "," + $v31 + "," + $v32
> > add-content $tempfile $vtot
> > $vtot = ""
> > Clean-Vars
> > }
>
Quote:

> > Any help will be appreciated.
>
Quote:

> > Hector
I have to recreate the format of the old GAL dump from the Exchange
5.5 days because it's being used as input for some external
processes. I'm cleaning the variables to make sure I don't carry
unwanted data. It is not meant to be part of the final product.

My System SpecsSystem Spec
Old 09-28-2007   #5 (permalink)
Brandon Shell


 
 

Re: end of line while processing a string token issue

It looks like the dump is suppose to be a CSV.. correct?

Have you looked at export-csv cmdlet.

"hectoritnt" <hectoritnt@xxxxxx> wrote in message
news:1190998457.839673.120640@xxxxxx
Quote:

> On Sep 28, 12:17 pm, "Brandon Shell" <tshell.m...@xxxxxx> wrote:
Quote:

>> As a note... If you decide to stick with the cleanup option... there is
>> much
>> better way IMO
>>
>> function Clean-Vars{
>> Param($Filter)
>> get-ChildItem variable: | Where-Object{$_.Name -match $filter} |
>> remove-Variable -whatif
>>
>> }
>>
>> The filter in this case would be "^v\d" I would recommend using a
>> variable
>> naming scheme that is more precise
>> like myTmpVarX then the filter would be "^myTmpVar\d"
>>
>> "hectoritnt" <hectori...@xxxxxx> wrote in message
>>
>> news:1190993581.745539.310020@xxxxxx
>>
Quote:

>> >I have this piece of code and can't figure out why it gives me this
>> > error every time.
>>
Quote:

>> > PS C:\Tools\Scripts> .\getusers.ps1
>> > Encountered end of line while processing a string token.
>> > At C:\Tools\Scripts\getusers.ps1:108 char:30
>> > + + $v30 + "," + $v31 + "," <<<< + $v32
>>
Quote:

>> > Code;
>>
Quote:

>> > $tempfile = "c:\temp.txt"
>>
Quote:

>> > function Clean-Vars
>> > { $v1 = ""; $v2 = ""; $v3 = ""; $v4 = ""; $v5 = ""; $v6 = ""; $v7 =
>> > ""; $v8 = ""; $v9 = ""; $v10 = ""; $v11 = "";
>> > $v12 = ""; $v13 = ""; $v14 = ""; $v15 = ""; $v16 = ""; $v17 = "";
>> > $v18 = ""; $v19 = ""; $v20 = ""; $v21 = "";
>> > $v22 = ""; $v23 = ""; $v24 = ""; $v25 = ""; $v26 = ""; $v27 = "";
>> > $v28 = ""; $v29 = ""; $v30 = ""; $v31 = "";
>> > $v32 = "" }
>>
Quote:

>> > $allusers = get-adobject -domain mcd.pri -pagesize 500 -filter
>> > "(&(mailNickname=*)(objectclass=user))
>> > Clean-Vars
>> > foreach ($one in $allusers) {
>> > $usrs = $usrs + 1
>> > $v1 = $one.objectclass[1]
>> > $v2 = $one.cn
>> > $v3 = $one.msExchHomeServerName.tostring()
>> > $v3 = $v3.split('=')[5]
>> > $v4 = $one.MDBOverquotalimit
>> > $v5 = $one.mDBUseDefaults
>> > $v6 = $one.mDBOverHardQuotaLimit
>> > $v7 = $one.mailnickname
>> > $v8 = $one.whencreated.tostring()
>> > $v9 = $one.whenchanged.tostring()
>> > $v10 = $one.sAMAccountName
>> > $v11 = $one.givenname
>> > $v12 = $one.sn
>> > $v13 = '"' + $one.displayname + '"'
>> > $v14 = $one.userprincipalname
>> > $v15 = $one.mail
>> > $v16 = $one.proxyaddresses
>> > $v17 = $one.ou
>> > $v18 = $one.msexchhidefromaddresslists
>> > $v19 = $one.altrecipient
>> > $v20 = $one.extensionattribute1
>> > $v21 = $one.deliverandredirect
>> > $v22 = $one.admindescription
>> > $v24 = $one.telephoneNumber
>> > $v25 = $one.pager
>> > $v29 = '"' + $one.memberof + '"'
>> > $v30 = $one.department
>> > $v31 = $one.tittle
>> > #
>> > $vtot = $v1 + "," + $v2 + "," + $v3 + "," + $v4 + "," + $v5 + ","
>> > + $v6 + "," + $v7 + "," + $v8 + "," + $v9 + "," + $v10 + "," + $v11 +
>> > "," `
>> > + $v12 + "," + $v13 + "," + $v14 + "," + $v15 + "," + $v16 + ","
>> > + $v17 + "," + $v18 + "," + $v19 + "," + $v20 + "," `
>> > + $v21 + "," + $v22 + "," + $v23 + "," + $v24 + "," + $v25 + ","
>> > + $v26 + "," + $v27 + "," + $v28 + "," + $v29 + "," `
>> > + $v30 + "," + $v31 + "," + $v32
>> > add-content $tempfile $vtot
>> > $vtot = ""
>> > Clean-Vars
>> > }
>>
Quote:

>> > Any help will be appreciated.
>>
Quote:

>> > Hector
>
> I have to recreate the format of the old GAL dump from the Exchange
> 5.5 days because it's being used as input for some external
> processes. I'm cleaning the variables to make sure I don't carry
> unwanted data. It is not meant to be part of the final product.
>
My System SpecsSystem Spec
Old 09-28-2007   #6 (permalink)
Brandon Shell


 
 

Re: end of line while processing a string token issue

Can you try this? It will not require cleaning up anything.

btw... I figured out your original problem.. missing " at the end of filter
"(&(mailNickname=*)(objectclass=user)) #<<<<

##############################
$tempfile = "c:\temp.txt"
$allusers = get-adobject -domain corp.bloomberg.com -pagesize 500 -filter
"(&(mailNickname=*)(objectcategory=user))"
$myObjCol = @()
foreach ($one in $allusers) {
$usrs = $usrs + 1
$myobj = "" | Select-Object
ObjectClass,cn,msExchHomeServerName,val,MDBOverquotalimit,mDBUseDefaults,
mDBOverHardQuotaLimit,mailnickname,whencreated,whenchanged,
sAMAccountName,givenname,sn,displayname,userprincipalname,
mail,proxyaddresses,ou,msexchhidefromaddresslists,altrecipient,
altrecipient,extensionattribute1,deliverandredirect,admindescription,
telephoneNumber,pager,memberof,department,title
$myobj.ObjectClass = $one.objectclass[1]
$myobj.cn = $one.cn
$myobj.msExchHomeServerName = $one.msExchHomeServerName.tostring()
$myobj.val = ($myobj.msExchHomeServerName).split('=')[5]
$myobj.MDBOverquotalimit = $one.MDBOverquotalimit
$myobj.mDBUseDefaults = $one.mDBUseDefaults
$myobj.mDBOverHardQuotaLimit = $one.mDBOverHardQuotaLimit
$myobj.mailnickname = $one.mailnickname
$myobj.whencreated = $one.whencreated.tostring()
$myobj.whenchanged = $one.whenchanged.tostring()
$myobj.sAMAccountName = $one.sAMAccountName
$myobj.givenname = $one.givenname
$myobj.sn = $one.sn
$myobj.displayname = '`"' + $one.displayname + '`"'
$myobj.userprincipalname = $one.userprincipalname
$myobj.mail = $one.mail
$myobj.proxyaddresses = $one.proxyaddresses
$myobj.ou = $one.ou
$myobj.msexchhidefromaddresslists = $one.msexchhidefromaddresslists
$myobj.altrecipient = $one.altrecipient
$myobj.extensionattribute1 = $one.extensionattribute1
$myobj.deliverandredirect = $one.deliverandredirect
$myobj.admindescription = $one.admindescription
$myobj.telephoneNumber = $one.telephoneNumber
$myobj.pager = $one.pager
$myobj.memberof = '`"' + $one.memberof + '`"'
$myobj.department = $one.department
$myobj.title = $one.title
$myObjCol += $myobj
}
$myObjCol | export-Csv $tempfile
#############################
"hectoritnt" <hectoritnt@xxxxxx> wrote in message
news:1190998457.839673.120640@xxxxxx
Quote:

> On Sep 28, 12:17 pm, "Brandon Shell" <tshell.m...@xxxxxx> wrote:
Quote:

>> As a note... If you decide to stick with the cleanup option... there is
>> much
>> better way IMO
>>
>> function Clean-Vars{
>> Param($Filter)
>> get-ChildItem variable: | Where-Object{$_.Name -match $filter} |
>> remove-Variable -whatif
>>
>> }
>>
>> The filter in this case would be "^v\d" I would recommend using a
>> variable
>> naming scheme that is more precise
>> like myTmpVarX then the filter would be "^myTmpVar\d"
>>
>> "hectoritnt" <hectori...@xxxxxx> wrote in message
>>
>> news:1190993581.745539.310020@xxxxxx
>>
Quote:

>> >I have this piece of code and can't figure out why it gives me this
>> > error every time.
>>
Quote:

>> > PS C:\Tools\Scripts> .\getusers.ps1
>> > Encountered end of line while processing a string token.
>> > At C:\Tools\Scripts\getusers.ps1:108 char:30
>> > + + $v30 + "," + $v31 + "," <<<< + $v32
>>
Quote:

>> > Code;
>>
Quote:

>> > $tempfile = "c:\temp.txt"
>>
Quote:

>> > function Clean-Vars
>> > { $v1 = ""; $v2 = ""; $v3 = ""; $v4 = ""; $v5 = ""; $v6 = ""; $v7 =
>> > ""; $v8 = ""; $v9 = ""; $v10 = ""; $v11 = "";
>> > $v12 = ""; $v13 = ""; $v14 = ""; $v15 = ""; $v16 = ""; $v17 = "";
>> > $v18 = ""; $v19 = ""; $v20 = ""; $v21 = "";
>> > $v22 = ""; $v23 = ""; $v24 = ""; $v25 = ""; $v26 = ""; $v27 = "";
>> > $v28 = ""; $v29 = ""; $v30 = ""; $v31 = "";
>> > $v32 = "" }
>>
Quote:

>> > $allusers = get-adobject -domain mcd.pri -pagesize 500 -filter
>> > "(&(mailNickname=*)(objectclass=user))
>> > Clean-Vars
>> > foreach ($one in $allusers) {
>> > $usrs = $usrs + 1
>> > $v1 = $one.objectclass[1]
>> > $v2 = $one.cn
>> > $v3 = $one.msExchHomeServerName.tostring()
>> > $v3 = $v3.split('=')[5]
>> > $v4 = $one.MDBOverquotalimit
>> > $v5 = $one.mDBUseDefaults
>> > $v6 = $one.mDBOverHardQuotaLimit
>> > $v7 = $one.mailnickname
>> > $v8 = $one.whencreated.tostring()
>> > $v9 = $one.whenchanged.tostring()
>> > $v10 = $one.sAMAccountName
>> > $v11 = $one.givenname
>> > $v12 = $one.sn
>> > $v13 = '"' + $one.displayname + '"'
>> > $v14 = $one.userprincipalname
>> > $v15 = $one.mail
>> > $v16 = $one.proxyaddresses
>> > $v17 = $one.ou
>> > $v18 = $one.msexchhidefromaddresslists
>> > $v19 = $one.altrecipient
>> > $v20 = $one.extensionattribute1
>> > $v21 = $one.deliverandredirect
>> > $v22 = $one.admindescription
>> > $v24 = $one.telephoneNumber
>> > $v25 = $one.pager
>> > $v29 = '"' + $one.memberof + '"'
>> > $v30 = $one.department
>> > $v31 = $one.tittle
>> > #
>> > $vtot = $v1 + "," + $v2 + "," + $v3 + "," + $v4 + "," + $v5 + ","
>> > + $v6 + "," + $v7 + "," + $v8 + "," + $v9 + "," + $v10 + "," + $v11 +
>> > "," `
>> > + $v12 + "," + $v13 + "," + $v14 + "," + $v15 + "," + $v16 + ","
>> > + $v17 + "," + $v18 + "," + $v19 + "," + $v20 + "," `
>> > + $v21 + "," + $v22 + "," + $v23 + "," + $v24 + "," + $v25 + ","
>> > + $v26 + "," + $v27 + "," + $v28 + "," + $v29 + "," `
>> > + $v30 + "," + $v31 + "," + $v32
>> > add-content $tempfile $vtot
>> > $vtot = ""
>> > Clean-Vars
>> > }
>>
Quote:

>> > Any help will be appreciated.
>>
Quote:

>> > Hector
>
> I have to recreate the format of the old GAL dump from the Exchange
> 5.5 days because it's being used as input for some external
> processes. I'm cleaning the variables to make sure I don't carry
> unwanted data. It is not meant to be part of the final product.
>
My System SpecsSystem Spec
Old 09-28-2007   #7 (permalink)
hectoritnt


 
 

Re: end of line while processing a string token issue

On Sep 28, 1:49 pm, "Brandon Shell" <tshell.m...@xxxxxx> wrote:
Quote:

> Can you try this? It will not require cleaning up anything.
>
> btw... I figured out your original problem.. missing " at the end of filter
> "(&(mailNickname=*)(objectclass=user)) #<<<<
>
> ##############################
> $tempfile = "c:\temp.txt"
> $allusers = get-adobject -domain corp.bloomberg.com -pagesize 500 -filter
> "(&(mailNickname=*)(objectcategory=user))"
> $myObjCol = @()
> foreach ($one in $allusers) {
> $usrs = $usrs + 1
> $myobj = "" | Select-Object
> ObjectClass,cn,msExchHomeServerName,val,MDBOverquotalimit,mDBUseDefaults,
> mDBOverHardQuotaLimit,mailnickname,whencreated,whenchanged,
> sAMAccountName,givenname,sn,displayname,userprincipalname,
> mail,proxyaddresses,ou,msexchhidefromaddresslists,altrecipient,
> altrecipient,extensionattribute1,deliverandredirect,admindescription,
> telephoneNumber,pager,memberof,department,title
> $myobj.ObjectClass = $one.objectclass[1]
> $myobj.cn = $one.cn
> $myobj.msExchHomeServerName = $one.msExchHomeServerName.tostring()
> $myobj.val = ($myobj.msExchHomeServerName).split('=')[5]
> $myobj.MDBOverquotalimit = $one.MDBOverquotalimit
> $myobj.mDBUseDefaults = $one.mDBUseDefaults
> $myobj.mDBOverHardQuotaLimit = $one.mDBOverHardQuotaLimit
> $myobj.mailnickname = $one.mailnickname
> $myobj.whencreated = $one.whencreated.tostring()
> $myobj.whenchanged = $one.whenchanged.tostring()
> $myobj.sAMAccountName = $one.sAMAccountName
> $myobj.givenname = $one.givenname
> $myobj.sn = $one.sn
> $myobj.displayname = '`"' + $one.displayname + '`"'
> $myobj.userprincipalname = $one.userprincipalname
> $myobj.mail = $one.mail
> $myobj.proxyaddresses = $one.proxyaddresses
> $myobj.ou = $one.ou
> $myobj.msexchhidefromaddresslists = $one.msexchhidefromaddresslists
> $myobj.altrecipient = $one.altrecipient
> $myobj.extensionattribute1 = $one.extensionattribute1
> $myobj.deliverandredirect = $one.deliverandredirect
> $myobj.admindescription = $one.admindescription
> $myobj.telephoneNumber = $one.telephoneNumber
> $myobj.pager = $one.pager
> $myobj.memberof = '`"' + $one.memberof + '`"'
> $myobj.department = $one.department
> $myobj.title = $one.title
> $myObjCol += $myobj}
>
> $myObjCol | export-Csv $tempfile
> #############################"hectoritnt" <hectori...@xxxxxx> wrote in message
>
> news:1190998457.839673.120640@xxxxxx
>
Quote:

> > On Sep 28, 12:17 pm, "Brandon Shell" <tshell.m...@xxxxxx> wrote:
Quote:

> >> As a note... If you decide to stick with the cleanup option... there is
> >> much
> >> better way IMO
>
Quote:
Quote:

> >> function Clean-Vars{
> >> Param($Filter)
> >> get-ChildItem variable: | Where-Object{$_.Name -match $filter} |
> >> remove-Variable -whatif
>
Quote:
Quote:

> >> }
>
Quote:
Quote:

> >> The filter in this case would be "^v\d" I would recommend using a
> >> variable
> >> naming scheme that is more precise
> >> like myTmpVarX then the filter would be "^myTmpVar\d"
>
Quote:
Quote:

> >> "hectoritnt" <hectori...@xxxxxx> wrote in message
>
Quote:
Quote:

> >>news:1190993581.745539.310020@xxxxxx
>
Quote:
Quote:

> >> >I have this piece of code and can't figure out why it gives me this
> >> > error every time.
>
Quote:
Quote:

> >> > PS C:\Tools\Scripts> .\getusers.ps1
> >> > Encountered end of line while processing a string token.
> >> > At C:\Tools\Scripts\getusers.ps1:108 char:30
> >> > + + $v30 + "," + $v31 + "," <<<< + $v32
>
Quote:
Quote:

> >> > Code;
>
Quote:
Quote:

> >> > $tempfile = "c:\temp.txt"
>
Quote:
Quote:

> >> > function Clean-Vars
> >> > { $v1 = ""; $v2 = ""; $v3 = ""; $v4 = ""; $v5 = ""; $v6 = ""; $v7 =
> >> > ""; $v8 = ""; $v9 = ""; $v10 = ""; $v11 = "";
> >> > $v12 = ""; $v13 = ""; $v14 = ""; $v15 = ""; $v16 = ""; $v17 = "";
> >> > $v18 = ""; $v19 = ""; $v20 = ""; $v21 = "";
> >> > $v22 = ""; $v23 = ""; $v24 = ""; $v25 = ""; $v26 = ""; $v27 = "";
> >> > $v28 = ""; $v29 = ""; $v30 = ""; $v31 = "";
> >> > $v32 = "" }
>
Quote:
Quote:

> >> > $allusers = get-adobject -domain mcd.pri -pagesize 500 -filter
> >> > "(&(mailNickname=*)(objectclass=user))
> >> > Clean-Vars
> >> > foreach ($one in $allusers) {
> >> > $usrs = $usrs + 1
> >> > $v1 = $one.objectclass[1]
> >> > $v2 = $one.cn
> >> > $v3 = $one.msExchHomeServerName.tostring()
> >> > $v3 = $v3.split('=')[5]
> >> > $v4 = $one.MDBOverquotalimit
> >> > $v5 = $one.mDBUseDefaults
> >> > $v6 = $one.mDBOverHardQuotaLimit
> >> > $v7 = $one.mailnickname
> >> > $v8 = $one.whencreated.tostring()
> >> > $v9 = $one.whenchanged.tostring()
> >> > $v10 = $one.sAMAccountName
> >> > $v11 = $one.givenname
> >> > $v12 = $one.sn
> >> > $v13 = '"' + $one.displayname + '"'
> >> > $v14 = $one.userprincipalname
> >> > $v15 = $one.mail
> >> > $v16 = $one.proxyaddresses
> >> > $v17 = $one.ou
> >> > $v18 = $one.msexchhidefromaddresslists
> >> > $v19 = $one.altrecipient
> >> > $v20 = $one.extensionattribute1
> >> > $v21 = $one.deliverandredirect
> >> > $v22 = $one.admindescription
> >> > $v24 = $one.telephoneNumber
> >> > $v25 = $one.pager
> >> > $v29 = '"' + $one.memberof + '"'
> >> > $v30 = $one.department
> >> > $v31 = $one.tittle
> >> > #
> >> > $vtot = $v1 + "," + $v2 + "," + $v3 + "," + $v4 + "," + $v5 + ","
> >> > + $v6 + "," + $v7 + "," + $v8 + "," + $v9 + "," + $v10 + "," + $v11 +
> >> > "," `
> >> > + $v12 + "," + $v13 + "," + $v14 + "," + $v15 + "," + $v16 + ","
> >> > + $v17 + "," + $v18 + "," + $v19 + "," + $v20 + "," `
> >> > + $v21 + "," + $v22 + "," + $v23 + "," + $v24 + "," + $v25 + ","
> >> > + $v26 + "," + $v27 + "," + $v28 + "," + $v29 + "," `
> >> > + $v30 + "," + $v31 + "," + $v32
> >> > add-content $tempfile $vtot
> >> > $vtot = ""
> >> > Clean-Vars
> >> > }
>
Quote:
Quote:

> >> > Any help will be appreciated.
>
Quote:
Quote:

> >> > Hector
>
Quote:

> > I have to recreate the format of the old GAL dump from the Exchange
> > 5.5 days because it's being used as input for some external
> > processes. I'm cleaning the variables to make sure I don't carry
> > unwanted data. It is not meant to be part of the final product.
Thank you very much. I will try it over the weekend.

My System SpecsSystem Spec
Reply

Thread Tools


Similar Threads
Thread Forum
Converting Get-ChildItems to string for processing. PowerShell
do something for each token in a line separated by comma PowerShell
Search for string in CSV and delete line if string found in line PowerShell
are there tutorial on string processing with power-shell? PowerShell
Encountered end of line while processing a string token PowerShell


Vista Forums is an independent web site and has not been authorized,
sponsored, or otherwise approved by Microsoft Corporation.
"Windows Vista", the Start Orb, and related materials are trademarks of Microsoft Corp.
© Designer Media Ltd

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46