Parse to columns every 2 char (including white space)

[dlesny]

Hello

I have a data in column which I would like to parse every 2 char.

Data represents days in a week every 2 char. It could be empty or have two letters code.

I need to split it to columns like that:

Sat	Sun	Mon	Tue	Wed	Thur	Fri
AC	AC	AC	AC	AC
	SH
	SH
		VA	VA
	NS	NS		NS	NS
NS		AS	AS	NS	NS	AS

ACACACACAC 
    SH       
    SH        
      VAVA   
  NSNS    NSNS
NS  ASASNSNSAS
    NS         
NS           
      VAVA   

[jdunkerley79 · Accepted solution]

You can use a RegEx tool in tokenize mode to get 2 characters and make this a field.

If you specify it to have 7 fields should get what you want

Quick sample attached

[Ladarthure]

Hi @dlesny,

you can use a simple regex to do so, just use the tokenize function in the regex tool and the correct regex is ".." one "." for each character, then specify you want 7 columns!

[echuong1]

You can achieve this using regex to identify a pattern. In this case, I identified sets of 2 (either an actual character/digit or a whitespace). Let me know if this works for your purpose! 

[dlesny]

Thank you very much, perfect