This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!
Submit FeedbackHi,
my solution attached here.
I Used a "Text to column" tool to split the text into columns, then select to change the names and the format of Poem_Id.
Then a RegEx tool to delete " from variable poem and another RegEx to replace ' at "Poem_Read_date". Tehn I used DateTime to convert "Poem_Read_date" to date.