Hey, I'm currently learning data processing using practical examples ... and no ... I don't make any money with it.
I have a street directory of around 12,000 streets.
Can someone who may have learned a job in data processing or have massive practical experience tell me what is the best way to use the database to compare?
In general, replace everything that is “ß” as “ss” (in Germany we have those stupid signs)?
Should I replace all spaces with no spaces so that I always get a contiguous string if there are no hyphens in it?
I've already read a lot but can't decide what the best way is to compare user input with the database.
(In this case we are talking about documents that are read out via AI and then flown into Excel with a plausible street)
I read about the Levenshtein distance method and thats pretty sexy, but unfortunately I can't get it implemented in power automate.
If you have any other tips or literature that you can read to get on the right path, It would be grateful.
Thank you best Regards