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.
I just replaced one text to column tool with regex tool. Apart from that, I could not do much to simplify the workflow. However, I am curious to know if the workflow I shared worked for your 500,000 records.