IES Enterprise Search for specific format

Thomas Taylor

I am using an API and search functionality to allow me to find where a field has a specific format of a string.

e.g REPN:0 AND CFJ0: ??????? AND RGDT:(YEAR(0) OR YEAR(-1))

this CFJ0 field is where i get more results than i require. I want to find only those with a Letter and the rest are numbers such as Z123456 BUT i also get ZZ23456

Is this possible to limitto the one alpha and the other 6  as numbers.

I know i can add where CFJ0 is like X?????? or Y?????? and combine those in the search search but i have too many letter options and run out of space for the query.

I was hoping for a range something like CFJ0: ([a-Z]??????)  or using something simialr to date ranges [20240101 TO 20200709].

seems it should be possible but just cannot find it.

thanks

Tommy

magnus-tallqvist

Can be worth trying to see in an interval like CFJ0:[A111111 TO Z999999] . In theory it could work since the value AA12345 should be less than Z999999 but I have never tested if that is the actual case. The wildcard ? gives back a result as long as there is a value regardless the type of value meaning the query A?? will return records with value A12, AAA but not A1 nor A