• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 82
  • Last Modified:

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

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
Hans de Jongh
Asked:
Hans de Jongh
  • 3
  • 2
1 Solution
 
MontoyaProcess Improvement MgrCommented:
you can create a calculated column that extracts the value that exists between the quotes, for example.
0
 
MontoyaProcess Improvement MgrCommented:
0
 
Hans de JonghAuthor Commented:
im sorry I should have said I need something for powershell..
0
 
Hans de JonghAuthor Commented:
$item["Factuurnummer Leverancier"]

oh that was simple:)
0
 
Hans de JonghAuthor Commented:
i found a solution online
0

Featured Post

Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

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