Solved

Regex validation questions with strings and numbers

5 years ago
16 August 2018
4 replies
144 views

sajeevan
0 replies

Hello,

Our group is developing surveys for a large study, and we give each participant an ID number. For new participants, the format is "AJA-XXXX" where the X's are digits 0-9. For visiting participants, the format is "AJA-XXXX.X." Here are some ID numbers that fit:

> * 1. AJA-2001
> * 2. AJA-2163
> * 3. AJA-2003.1
> * 4. AJA-2002.2
>

However, we don't want the following:
> * aja-2002 (first part not capitalized)
> * AJA3012 (no dash)
> * AJA-2009. (a period, but no digit afterwards)
> * AJA-1008.01 (two digits after the period)
>
After some googling, I came up with ``[t][r][t]\\-\\d{4}[\\.]?[\\d{1}]?`` but it didn't work

I would be extremely grateful for any help or suggestions. Thanks!

icon

Best answer by TomG 17 August 2018, 15:00

View original

4 replies

akshay11
QPN Level 2 ●●
25 replies
5 years ago
17 August 2018

I have tried this through javascript..

jQuery("[id='QR~QID15']").bind('keyup', function(e) {

var s=jQuery("[id='QR~QID15']").val();

if(s.length ==

{

if(s.substring(0,3) != "AJA" || s.charAt(3) != '-' )
{
alert("Wrong input");
}
else
{
var n=parseInt( s.substring(4,8) );
var i=0;

while(n!=0)
{
n=Math.floor(n/10);
i++;
}

if(i != s.substring(4,8).length)

alert("Wrong input");
}
}

if(s.length>8)

alert("Wrong input");
});

Userlevel 7

+27

TomG
Level 8 ●●●●●●●●
5546 replies
5 years ago
17 August 2018
Answer

Try this regex:
^AJA\\-[0-9]{4}(\\.[0-9])?$

One issue is that Qualtrics regex validation is case insensitive. So, you'll have to use JavaScript to convert to upper case.
```
Qualtrics.SurveyEngine.addOnload(function() {
jQuery("#"+this.questionId+" .InputText").on('blur', function() {
this.value = this.value.toUpperCase();
});
});
```

Userlevel 6

+21

PraDeepKotian_Ugam
QPN Level 5 ●●●●●
228 replies
5 years ago
17 August 2018

hi @sajeevan ,

Regex for this foramt e.g AJA-2001.1: /AJA-[0-9]{4}.[0-9]{1}/g
OR
Regex for this foramt e.g AJA-2001: /AJA-[0-9]{4}/g

You can use this regex in custom validation options.
!