Data Cleaning on DATE text

Support and Helpdesk Data cleaning and transformations
1

Hello,

I have this kind of text form and I want to get the day, month and year :

T-21 Wed Jan 01 14:21:57 2020 5

Thank you for your help

2

There are plenty of different ways to use GREL to split your text. My approach will be using the split function on the space and then concatenating the part you are interested in

value.split(' ')[1] + " " + value.split(' ')[2] + " " + value.split(' ')[3]

you can replace the " " with any separators, for example "-"