> > > ReplaceAll + Regex: Separate Numbers & Text

ReplaceAll + Regex: Separate Numbers & Text

31st October 2019

image


We have the challenge of taking the SINGLE alpha value of 48.5KG and breaking it into 2 separate fields. A numeric field and an alpha field, respectively.

In the example below we will show how to use the Cleo Clarify Ruleset Task ReplaceAll with Regex (Regular Expression) logic to accomplish this task.

Regex - Extract Alpha Values

image

Regex - Extract Numeric and Decimals

image


By: on