Field should contain either alphabets A-Z, numbers 0-9, and certain special characters

JHAROHIT

Hi,

I have a requirement to check in a field that it should contain only alphabets A -Z (both upper and lower case) , numbers 0 - 9, symbols like   .,-,\ and latin set  like ÀÈÌÒÙàè.

Can someone please guide how should i be writing the regex expression and also explain the syntax.

Appreciate your help in advance, Thank you.

OllieClarke

Hi @JHAROHIT you might need to be a bit more specific here. RegEx is very precise.

For instance, in Alteryx the token '\w' contains all uppercase and lowercase latin letters, all numbers, underscores, and all letters from non-latin alphabets (e.g. greek, sanskrit etc)

If that's okay with you, and you don't want underscores then the following filter should work:

REGEX_Match([Field],'[\w.\-\\]+') AND !CONTAINS([Field],'_')

You can construct a set of ranges of acceptable characters (escaping those with RegEx meanings). This would only match unaccented latin letters, numbers, fullstops, hyphens and backslashes.

[A-Za-z0-9\.\-\\]+

You could continue to add accented characters to this set, either by inputting them as a list, or putting in the first and last characters in their unicode range (as with A-Z). These ranges are easily found on ASCII tables, or Wikipedia, or google, but as I say we need to know exactly which character should be allowed and which ones shouldn't

Hope that helps,

Ollie