Split String Fields in parenthesis From the Right

Hello all,

I have data that looks like this:

ABC Corp (SAP 100) (20)

DEF (19)

GHI Inc HQ (190)

LMN (US) Holdings (SAP 2000) (1)

I want to get rid of only the last set of numbers in the string and keep the rest, so in the example above, I would want to get rid of:

(20)

(19)

(190)

(1)

I think the way I would do it is via RegEx, but not sure how to set it up. Would appreciate any assistance.

Tips and Tricks

Accepted answers

rituraj963

Hi @dataviolet,

I am not sure if Text to Column tool would do any trick here. I wrote some calculations in a Formula tool and it is extracting the text as you wanted. Please refer this workflow.

Let me know how it goes.

-Rituraj

Sample Text.yxmd

JosephSerpis

The Regex \s\(\d+\) will search for a space \s a bracket \( then a digit \d the + means one or more, so in this case one or more digits then another bracket \)

All comments

JosephSerpis

Hi @dataviolet I mocked up a workflow let me know what you think?

Regex_27082020.yxmd

rituraj963

Hi @dataviolet,

I am not sure if Text to Column tool would do any trick here. I wrote some calculations in a Formula tool and it is extracting the text as you wanted. Please refer this workflow.

Let me know how it goes.

-Rituraj

Sample Text.yxmd

dataviolet

Thank you, Rituraj! this is exactly what I was looking for. Could you also please explain to me the syntax that you used in the regex? Does the \s\ stand for text, and the \d stand for digits or something?

\s\(\d+\)

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335