Capturing six-digit numbers from unstructured text

BBlond — Thu, 11 Jun 2020 08:30:00 GMT

Hi all,

I have filled a collection from XLS but the data is currently not clean and workable. I have two columns: one with data items with a reference number, the other with corrresponding data items including text and several numbers. Each data item has at least one, but possible more, number that has six digits and starts with a "2". Let's call this Number X. It is not possible to predict where in the text field it is located.

Can anyone help me with filtering all the Number X's from the data?

------------------------------
Casper
------------------------------

RE: Capturing six-digit numbers from unstructured text

zdenek.kabatek — Fri, 12 Jun 2020 06:54:00 GMT

Hi, Casper,

are you familiar with regular expressions? Capturing 6 digits starting with 2 would look like this "2\d{5}" meaning that you need the first digit to be 2 and then any 5 digits. There is a business object called Utility Regex which returns the result.

Regards,

------------------------------
Zdeněk Kabátek
Head of Professional Services
NEOOPS
http://www.neoops.com/
Europe/Prague
------------------------------

topic Capturing six-digit numbers from unstructured text in Product Forum

Capturing six-digit numbers from unstructured text

RE: Capturing six-digit numbers from unstructured text