How to use RegEx extract in Eloqua?

Asked Apr 29 '20 at 08:08

Active Apr 29 '20 at 08:17

Viewed 35 times

im using Eloqua and theres a RegEx function, what I'm trying to achieve is to Extract all words after the first word and ONLY if the first word is [The]. An example here would be lets say i have a company called The Abc Inc, since the first word is [The], I want to extract only [Abc Inc]. How can I do this? I've tried a few ways ((?=[^The]).*), [^The\s](\w+)

Also Ive the system run this regex function only if the sentence contain the word [The], so anyhow i can just extract the second word onwards?

Here's an example to extract the domain from email address = ((?<=@).*?(?=[.].*))

edited Apr 29 '20 at 08:17

asked Apr 29 '20 at 08:08

John

Maybe you just need a capturing group? `^The (.+)` – Wiktor Stribiżew Apr 29 '20 at 08:09
Ok, then `(?<=^The ).+` will do – Wiktor Stribiżew Apr 29 '20 at 08:23
Hey @WiktorStribiżew ```^The (.+)``` works! didnt know it was that simple but thanks! – John Apr 29 '20 at 08:46

How to use RegEx extract in Eloqua?

0 Answers0