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_Le
ws_totaal_x0020_bedrag
the invoicenumber is 12345678
thanks!
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_Le
ws_totaal_x0020_bedrag
the invoicenumber is 12345678
thanks!
Last Comment
you can create a calculated column that extracts the value that exists between the quotes, for example.
I think I'd use the MID function
https://support.office.com/en-us/article/MID-function-2eba57be-0c05-4bdc-bf81-5ecf4421eb8a
https://support.office.com/en-us/article/MID-function-2eba57be-0c05-4bdc-bf81-5ecf4421eb8a
ASKER
im sorry I should have said I need something for powershell..
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
i found a solution online
Microsoft SharePoint
Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.
40K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
