Hi Everyone!
I’m fairly new to Knime (which I learn in Uni) and I need some help with one of my projects.
I have to extract the year from a string column, but my issue is that it has many different formats of dates.
I used the String manipulation node for another column, but I don’t know if I should use it for this or not. I guess I should use regex or wild cards some way(?)
I thank you in advance if you help me with your ideas!
Hi @Regina_Tth,
and welcome to the Knime community, it’s great to have you here.
Would you mind sharing the raw data please? It would spare us manually creating it from scratch and facilitate providing you a solution or at least an approach to it.
PS: I already solved it:
Let me know if that works your for you.
Many thanks in advance
Mike
Hi @mwiegand ! 
First of all, I would like to thank you for your help! I learned a lot from your solution.
I’m almost done with implementing it. I do have more data than the picture shows, so there is some more modification that I need to do, but they are similar to the last 2 String Replacer. So first I will try to figure it out myself, based on your workflow.
Thank you,
Regina
You are most welcome and good luck fully resolving it
PS: If my approach is a suitable solution, I’d love it you could mark it as the solution please.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
