split long number

T_Lina

Hi, 

I need to split a long number in this way: 

All numbers have the same length and need to be split in the same way.

first number: first 4 characters

second number: following 5 characters

etc.

Can someone explain how to do it?

Thanks a lot for your help. 

JosephSerpis

Hi @T_Lina one approach would be to use Regex. I mocked up an approach let me know what you think? With regex you can specify a pattern to retrieve in this case my expression looks for digits where I can specify a number \d{4} will look for 4 digits in a group as denoted by () for the rest your example I just followed the pattern and at the end I used (.*) which will find everything else. Regex can only work with string fields so you may need to convert your data before hand in order to use regex.  

Regex_24052021.yxmd