Regex Help - Data Between Two Spaces

[Mike_at_CG]

Hi Alteryx Community

Wanted to see if someone can help me with grabbing data between the first two spaces of a string?

Below is an example set of the data.

BNPPR 10.548 02-JAN-2031

The data I am trying to pull is the 10.548 in between BNPPR and 02-JAN-2031.

The first set of characters and last set might change but the data I need will always sit in between the first two spaces.

Thank you for your time

[DataNath · Accepted solution]

Hey @Mike_at_CG, if you use the RegEx tool in Parse mode then the following should work:

\s([^\s]+)

[binu_acs · Accepted solution]

@Mike_at_CG