Extracting series of integers from a statement

Question

Hello

I am trying to build a logic where I can extract a series of integers from a statement. the minimum length of those integers is 4 and it can go to any maximum length. Also, the integers can be at any place. Example,

1. This is a random statement 1234

2. This is 12345 a random statement

3. This is a random 123456 statement. I want my output as:

1. 1234

2. 12345

3. 123456

Can someone please help me in building this logic?

RobertOdera · Answer

Please consider the below @jerry239

Option1 = using Data Cleansing Tool

Option2 = using Regex \b\d{4,}\b

\b asserts a word boundary to ensure that we match whole numbers.
\d{4,} matches a digit (0-9) occurring 4 or more times.
\b asserts another word boundary to ensure that we match whole numbers.

Please like or mark as a solution if it works for you. Cheers!

For_jerry239.yxmd

aatalai · Answer

@jerry239 this might work using the data cleanse tool and slightly simpler than regex

Extracting series of integers from a statement.yxmd

Matt_D · Answer

Hi @jerry239  you could use (\d{4,}) instead of (\d+)

I'd make sure you cannot have something like "there are 2254 numbers in this 1234 sample statement." as the change will take the first number 2254 not 1234. Could this happen?

REGEX is fantastic but it still relies on a consistent pattern.