Split a string with an uncertain length into 2 characters per column

Question

Dear Alteryx Community
I am trying to split a string (the string length is uncertain; it could be 10 characters or 100 characters) into multiple columns, and each column should only contain 2 characters.

For example,

I am not sure how to do it, tried to use regular expression to parses the data with a fix number of characters and grouping like (..)(..) but it didn't work as I could cater for both short and long string lengths.

DataNath · Answer

Hey @vvcunha, glad to hear it worked well! As we've already sorted into the original order after the Cross-Tab, we can just conduct a join on the record position. The Join tool has built-in Select functionality and so we can remove the RecordID column and move fields around as needed to clean things back up as well:

Split fields into fields of 2 chars.yxmd

ShankerV · Answer

Hi @vvcunha

The Record ID tool which we already used in the workflow helps to bring back the original field to the dataset.

Hence used the join tool to add the Original Column for reference.

Please let me know if you have more questions.;

Many thanks

Shanker V

Final one Split a string with an uncertain length into 2 characters per column.yxmd

vvcunha · Answer

@DataNath @ShankerV
Thank youfor your solutions. They both worked  well  and did the job of spliting the the string the way I wanted to. 
I didn't expect Alteryx wouldn't haldeled creating 50rows for it data entry since I had over 20,0000 entries. I'm very surprised how it handled well.

One following up questions. In the final outcome the orginial Column disappeared and I couldn't figure  out in wich steps of the flow I could add it back on.

Thanks.