Parse Numbers with no space or delimiters

[dngnc7]

Hello, I need help on what approach to take in parsing numbers that have no space or delimiters into rows. Here is an example of what I need:

Original -> 1234567812345678

What I need-> 12345678

                        12345678

any suggestions are greatly appreciated.

[alexnajm]

What is the logic? Is it just every 8 digits?

[dngnc7]

every 16 digits

[alexnajm]

I am sorry but that doesn't make sense in relation to the example given above - in that case you have split a 16 digit number into two 8 digit rows. Can you clarify with concrete examples if the logic is different than previously stated?

[dngnc7]

I only need it to split where there are 16 digits.

[alexnajm · Accepted solution]

Otherwise if it is how you explained it, you can use the Tokenize method in the RegEx tool and Split to Rows. The expression would be \d{16} - change the number based on the split you need (my guess is that in reality it is \d{8})

[alexnajm]

Then filter you data to where Length([field])=16 - but again I think there are some conflicting statements so clarity would be preferred

[dngnc7]

This worked. You are awesome! thank you so much.