Splitting text from a date column
So, having trouble taking everything but the date from the date column in this one. There are extraneous words in there (Опубликовал - published) or the names of authors (Karimova, Администратор_сайта- [site administrator]) or Наиболее важные- the most important). Every time I seem to do it, it puts the words in another column.
I also need to take the time out from every date. I have tried to remove the terms I don’t want first and then split the column on the Cyrillic “B” (which means “in/at”) but can’t seem to get it to work.
The data set is here:(resultsto_0430.json - Google Drive) and the workflow is attached. Thanks in advance!