separating text by leng

I have a field of varying length. Some of the rows are 6 length which is what is needed. however some are multiples of six and i need those split out.

for example,

the column below

008334008847183194188052500306

needs to be split into multiple columns 008334 008847 183194 188052 500306

so this would now be five columns.

how would i do this?

Parse

Preparation

Accepted answers

AngelosPachis

Hi @parria1 ,

You can split on each digit and then count the number of digits to form groups of six. You can split to each digit via a RegEx tool.

Then it's just a matter of identifying the correct groups, before forming the complete 6-digits fields again.

Hope that helps.

Regards,

Angelos

example.yxmd

fmvizcaino

Hi @parria1 ,

Here is an example for you, it is achieavable using a group of tools described in the attached example.

Best,

FErnando Vizcaino

2021-01-06 separating text by leng.yxmd

All comments

AngelosPachis

Hi @parria1 ,

You can split on each digit and then count the number of digits to form groups of six. You can split to each digit via a RegEx tool.

Then it's just a matter of identifying the correct groups, before forming the complete 6-digits fields again.

Hope that helps.

Regards,

Angelos

example.yxmd

fmvizcaino

Hi @parria1 ,

Here is an example for you, it is achieavable using a group of tools described in the attached example.

Best,

FErnando Vizcaino

2021-01-06 separating text by leng.yxmd

parria1

your workflow works fine on my example but when i insert it into my larger production workflow it just outputs the first digit of the field instead of six. it splits it to rows, but each record as just the first digit of the field shown.

for example

RecordID Digit Group Output
1 0 008334
2 1 008334
2 2 008847
2 3 183194
2 4 188052
2 5 500306

becomes this

RecordID Digit Group Output
1 0 0
2 1 0
2 2 0
2 3 1
2 4 1
2 5 5

parria1

actually i do not need anything after the regex tool this is perfect, thanks.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15874

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703