Multiple Stringmanipulations and the best practice advice
This is my first contact in KNIME after I´m search for a fast data manipulation and automation workflow in gemini. I´m from germany (any german groups here?).
I need KNIME for adress manipulation operations. As you can see in my screenshot I´ve try to manipulate the “Briefanrede” variable. In this variable there are many mistakes and I will correct this or build my own one
Nachname contains Adelstitel und Namenszusatz. (Graf von) - only Zitzewitz is the nachname
Briefanrede Herr Professor Graf von Zitzewitz: only Sehr geehrter Graf von Zitzewitz is correct. When a “Adelstitel” is filled, the Briefanrede is only Adelstitel+Namenszusatz+Nachname. When in field AkadTitel is a Prof.Dr or Prof. or Prof. Dr. med. we only wrote something like Sehr geehrter Professor Mustermann. There are complex structures.
Which nodes are the best and easiest to build. I´m no script master. Perhaps it will be possible to show up all AkadTitel first, build a list of these and do a replacement with it?
Sorry for my english