UDF:

import java.util.regex.*; public static String checkRange(String vendorNumber) { if(Pattern.matches("1[A-Z]{2}[0-9]{6}",vendorNumber)) return "Internal"; else return "External"; }

Result: Any string between (1AA000000 -1ZZ999999)

Other Examples for numeric range http://www.regular-expressions.info/numericranges.html

• 000..255: ^([01][0-9][0-9]|2[0-4][0-9]|25[0-5])$
• 0 or 000..255: ^([01]?[0-9]?[0-9]|2[0-4][0-9]|25[0-5])$
• 0 or 000..127: ^(0?[0-9]?[0-9]|1[01][0-9]|12[0-7])$
• 0..999: ^([0-9]|[1-9][0-9]|[1-9][0-9][0-9])$
• 000..999: ^[0-9]{3}$
• 0 or 000..999: ^[0-9]{1,3}$
• 1..999: ^([1-9]|[1-9][0-9]|[1-9][0-9][0-9])$
• 001..999: ^(00[1-9]|0[1-9][0-9]|[1-9][0-9][0-9])$
• 1 or 001..999: ^(0{0,2}[1-9]|0?[1-9][0-9]|[1-9][0-9][0-9])$
• 0 or 00..59: ^[0-5]?[0-9]$
• 0 or 000..366: ^(0?[0-9]?[0-9]|[1-2][0-9][0-9]|3[0-5][0-9]|36[0-6])$

Regular Expressions (Regex) usage in PI Mapping