Parse input data into equal length

[Alt_dp]

Team,

I have a text input that i want to parse through using length as a condition. In the attached example, i want to split the field if the text size is 9. Is my regular expression wrong? Can you guys help?

[Bob_Blackey]

Hi,

Can you give an example of an input record and the desired output?

In this case do you want to separate the field into nine digit chunks? In that case I would use the Tokenize option instead and use the Split to Rows option in the Regex tool. You can keep the Regular Expression the same.

Cheers,

Bob

[MarqueeCrew · Accepted solution]

@Alt_dp,

I've created a sample workflow that will divide into 9byte fields.

Cheers,
Mark

[Federica_FF]

Hi @Alt_dp,

if you use the parse method, you have to put the part you want to extract/parse between parenthesis (\d{9}).

But this way you only get the first 9 characters of your strings. You maybe/probably want to split your long string into N smaller strings made of 9 digits?

In this case you could try the tokenize method, tokenize to rows or to columns. See attached file!

[Alt_dp · Accepted solution]

@MarqueeCrew You read my mind. Thanks for the solution and quick turn around