Splitting data evenly into 3 columns

TP-90

Hello,

I am new to Alteryx and I am trying to split the data evenly into 3 columns but couldn't able to find a workaround to achieve this problem.

For Example: In my workflow, I am getting below output, which is not splitting correctly.

My Output Result
PBS	P	B	S
123-456789-AA	123	456789	AA
555-6666-DDD	555	6666	DDD
LM5555-AAA	LM5555	AAA
CM666-BBB	CM666	BBB
JHS55-CCC	JHS55	CCC

Below is the corrected output:

Correct Output Result
PBS	P	B	S
123-456789-AA	123	456789	AA
555-6666-DDD	555	6666	DDD
LM5555-AAA		LM5555	AAA
CM666-BBB		CM666	BBB
JHS55-CCC		JHS55	CCC

Thank you so much.

danilang

Hi @TP-90 

My knowledge of Regex isn't quite up to the point of doing this one statement, but by adding a formula tool to artificially add a initial hyphen if it's missing, then a Regex parse on Hyphen will split and correctly align your data

Maybe @Thableaus can respond with a single Regex solution

Dan

Split.yxmd