Community

Data verification error for white space

I set a requirement for a field specifying [ ,.0123456789]{0-20}, allowing numbers, comma, period and white space. However it gave me error for a text "0 00". So I did this test where only allows white space: [ ]{0-20} and there you have it, spaces are counted as error. And I actually selected the white space from the group so I assume it should work. What may be an explanation for this error? Thanks.

Was this article helpful?

0 out of 0 found this helpful

Comments

3 comments

  • Avatar
    Permanently deleted user
    Hello, lliu.

    There is a special symbol for white space in FlexiCapture - \s. So, try to use this regular expression: ([\s] | [0123456789.,]){0-20}.

    I hope it helps you.
    0
  • Avatar
    Permanently deleted user
    Hello, lliu. There is a special symbol for white space in FlexiCapture - \s. So, try to use this regular expression: ([\s] | [0123456789.,]){0-20}. I hope it helps you.


    That works. Thank you so much. Not sure why the one from the character selection doesn't work. Also can you detect new line in text? Mostly when capturing paragraph it comes with a new line symbol I think. I tried [\n] but that doesn't work.
    0
  • Avatar
    Permanently deleted user
    I daresay, there is no way to detect a new line by the regular expression in validation settings. But you may use rule script for it.
    0

Please sign in to leave a comment.