How to extract all characters after the first match, without including the first match

Question

I have these strings, and I'm looking to extract all characters after the first _. For example:

'hello _I _ am _ 123312'
'Nobody sa_dwdq casc_as _ 1233_12'
'_dosjadojs aod jao jdaso j'

The output expected:

' I _ am _ 123312'
'dwdq casc_as _ 1233_12'
'dosjadojs aod jao jdaso j'

This is the closest answer I found, but it's not in BigquerySQL language.

And this is what I have got so far, but it includes the matched character and I haven't found a way to not include the matched character through regex:

REGEXP_EXTRACT(str, r'_.*')

Why is there a space before the `I` in the first expected output? — Bohemian, Jun 23 '22 at 16:32

score 1 · Answer 1 · answered Jun 23 '22 at 16:57

1

Use REGEXP_REPLACE instead to match what you don't want and delete that by replacing with blank:

REGEXP_REPLACE(str, r'^.*?_', '')

answered Jun 23 '22 at 16:57

Bohemian

412,405
93
575
722

score 0 · Accepted Answer · edited Jun 23 '22 at 16:41

0

Here is one way to do it,

https://regex101.com/r/voPDE5/3

_(.*)

_ : Non Capturing group, matching exactly one occurrence of "_"  
(.*) : Captures the remainder of the string

edited Jun 23 '22 at 16:41

Wiktor Stribiżew

607,720
39
448
563

answered Jun 23 '22 at 16:35

Naveed

11,495
2
14
21

Thanks @Wiktor, your edit made it even simpler. Regards – Naveed Jun 23 '22 at 16:42
1

Yeah, `(?:a){1}(?:b){1}(?:c){1}` = `abc` – Wiktor Stribiżew Jun 23 '22 at 16:45

How to extract all characters after the first match, without including the first match

2 Answers2