So, picture this: a brand-new customer strolls into our system, and we're all excited. But here's the catch - they might have this fancy VAT Registration No, and we've got this EU Validation Service that's basically our VIP portal to snagging their name and address. Now, the problem is, their full address is playing hide-and-seek in a single field, like it's on a secret mission or something. We want to break up that stealthy address into three amigos: Address, City, and Post Code. It's like giving our AI child a little detective mission to unravel the mysteries of addresses. Let's see if our brainy offspring can crack the code and make our customer data as organized as a cat lady's yarn collection! 🕵️♂️💡
Comments
Thanks! I'm using AI. This one will sure be helpful :D
Category: Financial Management
Sure, here is one example for Austrian Address:
Alpenstraße 1185 AT-5020 Salzburg
Are you interpreting text or using AI? Because the address format differs from country to country.
Category: Financial Management
I already did this. It does not work perfectly for every situation (way how address is written) I found, so I make adjustment based on the input every time. Do you have any examples so I can fine tune solution?
I would than publish it on GitHub.
Category: Financial Management
The issue exists in some EU countries but not in all EU countries. Therefore, the proposed solution might be implemented only for the countries for which webservice response contains the full Address in a single field which is suboptimal.
Category: Financial Management
Translation serious language:
When new customer is created there is possibility to enter EU VAT Registration No and use EU Validation Service in order to fetch Customer Name and Address. The full Address is often condensed in a single field and gets transferred to the Customer field "Address". However, the full address contains Street, City and Post Code. Desired behavior is to split full address in three customer fields named Address, City and Post Code. As AI is around the corner looking curios at the humanity, I think it makes sense to explore whether we could employ this child of ours for the purpose of breaking the full address into three separate fields.
Category: Financial Management