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.
@al_sweets The solution above would work, but that presumes that you know the maximum number of values that will be in each field. in case you're not sure (and with 800,000 values I'm not confident you would be) then the attached solution would work.
Parsing to rows allows for a variable field length. The attached workflow would account for this.
To answer your earlier question, a regex could be used, but isn't necessary.