Expression

[John Otto Knoke]

Hello,

I have been trying this simple expression, but without success. I am trying to filter only characters without numbers.

Appreciate any help.

[Tom Morris]

The best regular expression will probably depend on the context because they get used slightly differently in different places, but it looks like you're working with a Text Filter facet.

The first thing I'd try is: 

    ^[^0-9]*$

which will restrict the entire cell value to zero or more non-numerics.

The Text Filter facet is more permissive than other contexts in that it'll match substrings by default, whereas GREL functions typically match the entire value (so you need to explicitly wrap your RE with .* on either side, if you want the more common substring style matching).

Tom

--
You received this message because you are subscribed to the Google Groups "OpenRefine" group.
To unsubscribe from this group and stop receiving emails from it, send an email to openrefine+...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[John Otto Knoke]

Thanks Tom! Work perfect in the text filter. I understand the *$ at the end but don't understand ^ at the beginning.

Thanks again!

[Tom Morris]

It's a little confusing because ^ has two different meanings in this expression: negation (in your original character class) and beginning-of-string anchor (which I added).  $ is the end-of-string anchor and * means zero or more (which you may want to change to + for 1 or more, depending on what you're trying to achieve).

Tom

[John Otto Knoke]

Got it thanks.

[John Otto Knoke]

Hello,

Can someone help understand what I am doing wrong with this expression using the value.replace

value.replace(\^[^a-zA-Z0-9]\,'')

My goal is to remove any non-word characters at the beginning. 

Thanks for the help

[Owen Stephens]

I think this is as simple as using the wrong direction slash at the start/end of your regular expression. Try:

value.replace(/^[^a-zA-Z0-9]/,’')

(n.b. this will replace just a single non-alphanumeric char. To remove any number of leading non-alphanumeric chars you need to add a * to the expression:

value.replace(/^[^a-zA-Z0-9]*/,’')


Owen

[John Otto Knoke]

Thank you Owen, 5 minutes after I posted, I fixed the slashes. 

Owen