What is the right regex for extracting string after first symbol?

Question

In google data studio I would like to make a REGEXP_EXTRACT for getting the string after the first | symbol (https://regex101.com/r/w3BqW4/2). I've tried the regex:

[|].*?$

but this is returning:

' | Leren afzaklaarzen Elisio | kalk'

So I still need to lose the first ' | '. Can anyone help me?

Example:

Input: Toral | Leren afzaklaarzen Elisio | kalk

Output: Leren afzaklaarzen Elisio | kalk

Please share the code you tried to get an idea of what problem you have. — Wiktor Stribiżew, Feb 28 '20 at 14:35
@AkinOkegbile with the regex, '[|].*?$' it's returning: | Leren afzaklaarzen Elisio | kalk. So I still need to lose the first ' | '. — Sam, Mar 02 '20 at 13:41
You have no capture groups, so how are you expecting to extract things? — OneCricketeer, Mar 02 '20 at 15:42

Nimantha · Accepted Answer · 2020-03-02T16:42:24.873

1

Adding a capturing group () to the initial RegEx does the trick:

REGEXP_EXTRACT(Field, "[|](.*)?$")

Adding the suggestion by cricket_007 "You cannot have "zero or one" of "zero or more" characters":

REGEXP_EXTRACT(Field, "[|](.*)$")

Google Data Studio Report to demonstrate:

edited Mar 02 '20 at 16:42

answered Mar 02 '20 at 16:34

Nimantha

6,405
6
28
69

OneCricketeer · Answer 2 · 2020-03-02T16:36:25.387

0

If you want to capture every character after the first vertical bar, that would look like this

\\|(.*)$

You don't need question mark after a .*

edited Mar 02 '20 at 16:36

answered Mar 02 '20 at 15:44

OneCricketeer

179,855
19
132
245

When i'm trying you regex in https://regex-golang.appspot.com/assets/html/index.html it's output is the same as the input. – Sam Mar 02 '20 at 16:21
Well, looking at the REGEXP_EXTRACT documentation, this seems to be want you want – OneCricketeer Mar 02 '20 at 16:27
I only want to group: 'Leren afzaklaarzen Elisio | kalk' – Sam Mar 02 '20 at 16:31
I see that. Try regex101 again. Add the ungreedy modifier. It works for me – OneCricketeer Mar 02 '20 at 16:36

What is the right regex for extracting string after first symbol?

2 Answers2