Extract Sub string using Regular Expressions

Question

I have a column called path like below. I want to extract the sub strings 'AMERICANS','APAC','EAME' from each row. I am hence looking for a Regex which can do this for me. I am not very good at Regex. Can anyone please help me with this ? I need a Java Regex

Path

F:\Email Alias\AMERICIANS\Americas - Team
F:\Email Alias\AMERICIANS\Americas - Territory
F:\Email Alias\AMERICIANS\Americas- Market
F:\Email Alias\APAC\APAC - Market
F:\Email Alias\EAME\EAME - Team

Required:

AMERICANS
AMERICIANS
AMERICIANS
APAC
EAME

Thank You.

Regular expressions return true or false... you will have to split your string at every "/" and chop that into an array. You have provided a minimum of detail and that is why I keep my answer this short - I am not willing to do more work than you ;) — Max Bumaye
– Max Bumaye, Commented Nov 17, 2014 at 10:21

Avinash Raj · Accepted Answer · 2014-11-17 10:20:19Z

1

The below regex would match the strings you want.

[^\\]+(?=\\[^\\]*$)

DEMO

i think you need to escape the backslash one more time in qregularexpression.

Regular Expression:

[^\\]+                   any character except: '\\' (1 or more
                         times)
(?=                      look ahead to see if there is:
  \\                       '\'
  [^\\]*                   any character except: '\\' (0 or more
                           times)
  $                        before an optional \n, and the end of
                           the string
)                        end of look-ahead

answered Nov 17, 2014 at 10:20

Avinash Raj

175k32 gold badges247 silver badges289 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Alan Moore Over a year ago

FYI, it appears the regex flavor is Java, not QRegularExpression. I've retagged it, but your double-escaping advice still applies.

Collectives™ on Stack Overflow

Extract Sub string using Regular Expressions

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related