Capturing six-digit numbers from unstructured text

[BBlond]

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
------------------------------

[zdenek.kabatek]

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
------------------------------