Split string into multiple rows

Hello everyone,

I'm trying to split a string to rows based on two conditions:

1- Each row value should start with 6

2- And have a length of 10 chars.

Example:

Before:

612345689760012255876000011111

After:

6123456897

6001225587

6000011111

Is there any way to do that? or even a way to insert a space or delimiters after every 10 digits that starts with 6?

Thank you all!

Workflow

Accepted answers

Hi @MonaAlmutairi

You can Regex tool tokenize method with below regex to split.

6 followed by 9 digits

Hope this helps : )

6 and split.yxmd

All comments

Hi @MonaAlmutairi

You can Regex tool tokenize method with below regex to split.

6 followed by 9 digits

Hope this helps : )

6 and split.yxmd

Hi @MonaAlmutairi

You can learn more about Regex from the below links

https://community.alteryx.com/t5/Interactive-Lessons/Parsing-Data-with-RegEx/ta-p/441415

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-RegEx/ta-p/37689

In addition to the above resources, you can use https://regex101.com/ as a sandbox for building and testing out regex. The tool is very intuitive for step-by-step regex building.

This should help you get started with the amazing journey of Regex 🙂

Hope this helps : )

@atcodedog05 Thank you so much, that was helpful!

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15880

MarqueeCrew 13708

apathetichell 13703