Goodmorning everyone,
I'd like to ask a question about the validation of files to be imported into Microsoft Dynamics NAV 2017. Let me explain better, I often have to import (e.g. through XMLPort) files that come from third parties that have a "table structure" different from mine; concrete example, in my table I could have a field related to VAT that is populated with 22, while for the "external" one ( the one to be imported) is populated with "22%" (or maybe "Twentytwo", or "22 per cent", and so on and so forth). The question is: how can I validate these values? How can I transform them "respecting my standard"? In general I would like to understand if there is the possibility to make some operation during the import of an external file
I hope I've been sufficiently clear.
Thank you so much for your attention
0
Answers
Dynamics NAV, MS SQL Server, Wherescape RED;
PRINCE2 Practitioner - License GR657010572SG
GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03
Yes, you can. But the hard thing is how to find the pattern; maybe you should work with strpos to find that.
Group | Third Parties Value | NAV Value
VAT | 22% | 22
VAT | Twentytwo | 22
VAT | 2 per cent | 22
VAT | ... | 22
Write your code to access this table to get the NAV value.