Split String Fields in parenthesis From the Right

[dataviolet]

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.

[JosephSerpis]

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

[rituraj963 · Accepted solution]

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

[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+\)

[JosephSerpis · Accepted solution]

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 \)

[dataviolet]

Thank you, Joseph, for the detailed breakdown!