Hi guys,
I have two problems
1.
I have an invoice in PDF format.
In addition, I have an Excel list with departments and their abbreviations which should but do not have to appear in this invoice.
The location of the department name in the invoice is not fixed, and can be arbitrary.
Is it possible to match the Excel list against the PDF to get the following condition
Department in Invoice PDF = Department which is stored in SAP;
if no, then replace the department in SAP with the department stored in Excel list.
2.
I have an XML file from which I need to extract certain values. The values can always be in different places, but always have the same header.
As an example.
Invoice date must be read out.
Header = StartDateTime
shortly thereafter comes the date that must be read out.
I have a hard time because the data are not always in the same lines and also many unnecessary text between the data and partly in the same lines as the data are.
Do you have an idea how I can filter out the specific values?
Thanks a lot guys!
