Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 128
  • Last Modified:

powershell Excel formula data resolving for powershell

Dear friends,

the  problem in this formula is "&L151& $db"
ii've a special case to insert Text from a cell with result of variable to description. How could i write that?

="$db = (Get-Mailbox -Identity "&A151&" | Select-Object -expand Database);;set-aduser -identity "&A151&"  -description "&L151& $db"

L151 contents the text. the result should be  "text  DB001"
$DB is e.g. DB001

="$db = (Get-Mailbox -Identity "&A151&" | Select-Object -expand Database);;set-aduser -identity "&A151&"  -description "&L151& $db"

Open in new window


Thanks in advance
0
Mandy_
Asked:
Mandy_
  • 2
1 Solution
 
Mandy_Author Commented:
write first one value to description then get it again as variable  and write it with other variable

="$db = (Get-Mailbox -Identity "&A151&" | Select-Object -expand Database);set-aduser -identity "&A151&"  -description  "&M151&";$desccurrent = (Get-ADUser -identity "&A151&" -Properties Description).Description;set-aduser -identity "&A151&" -description ($desccurrent+' '+$db)")

Open in new window

0
 
Mandy_Author Commented:
No comments afterlong time. resolve by myself.  write first one value to description then get it again as variable  and write it with other variable
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now