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!
Hans de JonghAsked:
Who is Participating?
 
Hans de JonghAuthor Commented:
$item["Factuurnummer Leverancier"]

oh that was simple:)
0
 
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:
i found a solution online
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.