Looking for only the numbers that come before a certain word

Question

I have a dataset with a messy 'comments' column. I want to extract numbers from these comments, but only when the come before a ceratin word. For instance, a comment could be:

on januari 21, 16 boats passed

or

21 boats passed on januari 12 2017

I only want the numbers when they come beofre the word 'boat'. Is there a way to do that?

Page 1 / 1

StringSearcher with regex should do this.

Thanks. I was struggling with the regex, but found it: \\d+(?=\\ boats)

Reply

nielsgerrits · Accepted Answer

StringSearcher with regex should do this.

michiedem · Answer

StringSearcher with regex should do this. Thanks. I was struggling with the regex, but found it: \d+(?=\ boats)

Reply

Community Stats

Sign up

An FME Account is required to contribute

Login to the community

An FME Account is required to contribute

Scanning file for viruses.

This file cannot be downloaded