Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Text to Columns or Regex - Tokenize?

_collin_lowney
7 - Meteor

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.

 

Any help is much appreciated

3 REPLIES 3
Joe_Mako
12 - Quasar

Another option since you are downloading a .csv file, is to download to a temp file, and then use Dynamic Input to read that file.

 

(When you open the attached file, ignore the red exclamation mark before running, it just means it cannot file the temp file I used to set the format, CSV comma separated with no header row)

 

download temp.png

_collin_lowney
7 - Meteor

Excellent - Thanks for the quick reply!

NicoleJohnson
ACE Emeritus
ACE Emeritus

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 :)

 

NJ

Labels