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.
Im trying to import a .CSV from a website and I am able to use text to columns to get my first row of data sorted but the remaining data in 'Field 7' I need to start a new row of 6 Fields......there should be around 5500 rows altogether,? Im sure there is any easier way with the Regex tool and Tokenize, but I am having trouble getting a result.
If you use the Text to Columns tool to split your data into Rows based on the newline delimiter (\n) first, and then use another Text to Columns tool to split your data (that is now broken out into individual rows) in the DownloadData field into the required number of columns, I believe that will also give you the results you're looking for.
But I do like @Joe_Mako solution too for being so dynamic :)