New reply on DataCleaner's online discussion forum
(https://datacleaner.org/forum):
Dennis replied to subject 'RegEx'
-------------------
Hi Dom,
What is the issue you're seeing? As I'm testing, it seems to work as intended:
{{{
GCE
-A Level
AS
'A2'
A2
}}}
... Are all caught when I use that regex, other strings (except of course other
non-word characters in front of "A Level") are not.
Are you possibly expecting it to catch them even if in the middle of other
text? We're matching on the complete text, so in that case you'll need to
sandwich your regex in ".*", like this:
{{{.*((\bGCE\b)|([^\w]A\sLevel)|(\bAS\b)|('?A2'?)).*}}}
Hope that helps, otherwise you'll have to give some examples of values you
expect to match and values you don't.
-------------------
View the topic online to reply - go to https://datacleaner.org/topic/1159/RegEx
--
You received this message because you are subscribed to the Google Groups
"DataCleaner-notify" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/datacleaner-notify.
For more options, visit https://groups.google.com/d/optout.
