Solved

powershell Excel formula data resolving for powershell

Posted on 2014-09-17
2
119 Views
Last Modified: 2014-09-19
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
Comment
Question by:Mandy_
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
2 Comments
 
LVL 2

Accepted Solution

by:
Mandy_ earned 0 total points
ID: 40334098
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
 
LVL 2

Author Closing Comment

by:Mandy_
ID: 40334099
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

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A quick Powershell script I wrote to find old program installations and check versions of a specific file across the network.
Outlook for dependable use in a very small business   This article is about using the Outlook application (part of Microsoft Office) in a very small business, or for homeowners where dependability and reliability are critical requirements. This …
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

729 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question