Solved

How can i fill a variable with data from another variable (which has a xml part)

Posted on 2014-12-04
5
68 Views
Last Modified: 2014-12-09
Hello,

I have a variable filled with an sharepoint item.

Now this item array has an xml field. In this XML field I have certain fields I need

so I have
$item.xml

and I need in $invoice a number which is in that xml in the following text:
ows_Factuurnummer_x0020_Leverancier='12345678' o
ws_totaal_x0020_bedrag

the invoicenumber is 12345678

thanks!
0
Comment
Question by:Hans de Jongh
  • 3
  • 2
5 Comments
 
LVL 19

Expert Comment

by:Iammontoya
ID: 40481141
you can create a calculated column that extracts the value that exists between the quotes, for example.
0
 
LVL 19

Expert Comment

by:Iammontoya
ID: 40481149
0
 

Author Comment

by:Hans de Jongh
ID: 40481472
im sorry I should have said I need something for powershell..
0
 

Accepted Solution

by:
Hans de Jongh earned 0 total points
ID: 40481654
$item["Factuurnummer Leverancier"]

oh that was simple:)
0
 

Author Closing Comment

by:Hans de Jongh
ID: 40488441
i found a solution online
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Utilizing an array to gracefully append to a list of EmailAddresses
Are you one of those front-line IT Service Desk staff fielding calls, replying to emails, all-the-while working to resolve end-user technological nightmares? I am! That's why I have put together this brief overview of tools and techniques I use in o…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

757 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now