Break a single string column to multiple rows

I have a single string column with value sample as "abcdefghijklmnop", i need this value to be split into multiple rows with each row contains 5 letters.

Expecting Output;

Result:

abcde

fghij

klmno

Tried using generate rows but couldn't find the solve

Regex

Parse

Preparation

Accepted answers

ganesamurthy

Hi,

I am attaching my solution to this problem. Hope it helps.

Thanks.

MultiSplitString_251019.yxmd

All comments

JosephSerpis

Hi @SGR_Altryx I mocked up a solution that produces your output. Let me know what you think?

String_241019.yxmd

SGR_Altryx

Thanks for the solution.

But,

Data Volume for which i have to implement is very huge. I have 4 million line item with each row value

having on a average of 8000 characters.

why is that using Generate Row tool cannot be used in this case?

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703