Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2014-12-04
5
Medium Priority
?
79 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:Montoya
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:Montoya
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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Windows 10 came with  a lot of built in applications, Some organisations leave them there, some will control them using GPO's. This Article is useful for those who do not want to have any applications in their image (example:me).
A walk-through example of how to obtain and apply new DID phone numbers to your cloud PBX enabled users that are configured in Office 365. Whether you have 1, 10 or 100+ users in your tenant, it's quite easy to get them phone-enabled and making/rece…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…
Loops Section Overview

916 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