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 FeedbackThanks, David. I learned the parsing toolset from you.
I love to know how to change the date format.
@Avinash_K wrote:Have two approaches one using regex and other one using text to column
Hi Avinash,
I learned from you as well.
Where can I find the expression on the Regular Expression tool ?
^"(\w.*)"\,(.*)\,'(.*)'