Parse to columns every 2 char (including white space)

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

Datasets

Developer

Regex

Expression

Data Investigation

Accepted answers

jdunkerley79

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

RegexTokens.yxmd

All comments

jdunkerley79

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

RegexTokens.yxmd

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!

New Workflow5.yxmd

dlesny

Thank you very much, perfect

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703