I have a field which contains product names with measurement unit in the same field.
"Product Name 100grams" or "Product Name 500ml"
I want to create a formula to extract 100grams or 500ml (these measurement units need not to be in the last place of the field.
Is there any way to grab these units?
This formula returns a string consisting of the last word of the product name with the numerical value removed.
If the last word does not contain a numeric value, nothing is returned.
IF(
REGEX_MATCH({Name}, ".* [\\d.,]+(.*$)"),
REGEX_EXTRACT({Name}, ".* [\\d.,]+(.*$)")
)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.