Does DT do regex negative look aheads? I know on some measurements there is the option of "not regex" which is great, but where there is only transformation regex I need to to exclude text i.e I want "Loading" not to be shown so I'd expect this to work:
^((?!Loading).)*
The regex tester does not like it.
Answer by Matthew S. ·
Had an epiphany!! ^((?!Loading).*) works....
Yes.. the * works inside the brackets in DT (it does work in regex testers outside the bracket!!)
Answer by Rajesh S. ·
Haven't tried look arounds. Could you test it in different test BT?
If your data has some structure/format you can avoid selecting text by splitting regex into multiple expressions. And capture only what is needed.
Like : (.*)Loading(.*)|(.*)
Yes, the inbuilt tester works not. Check out https://regex101.com/
Can you enlist some text samples that occur in your data?
JANUARY 15, 3:00 PM GMT / 10:00 AM ET