String Validation in specific format
Hi,
Is there any OOTB function to which can be customized to validate a string in the below format? It contains alphanumeric as well as specific special character (.) in specific position.
Format: letter/dot/8 numbers/dot/3 numbers
Example: X.50009999.567
***Edited by Moderator Marije to add Capability tags***
Accepted Solution
Updated: 4 Nov 2022 3:20 EDT
Capgemini
DE
@BhanuPrakash_G Thank you for your reply. The expression is working for the invalid letters (in first position) and the digits as well. But it does not validate the special characters (.) correctly. For example: It is failing for a String = X:50009999,567
Is there a way to validate the special character to only accept dot (.) in the same expression?
But I understand that we can validate the special character to accept only dot (.) using substring. Therefore, this solution would work anyways.
Updated: 4 Nov 2022 3:12 EDT
JPMC
IN
@Nabendu Could you try this function with the below pattern
@String.pxContainsViaRegex(Param.SourceString,Param.Pattern,false)
Param.SourceString = X.50009999.567
Param.Pattern = [A-Za-z].\d{8}.\d{3}
Accepted Solution
Updated: 4 Nov 2022 3:20 EDT
Capgemini
DE
@BhanuPrakash_G Thank you for your reply. The expression is working for the invalid letters (in first position) and the digits as well. But it does not validate the special characters (.) correctly. For example: It is failing for a String = X:50009999,567
Is there a way to validate the special character to only accept dot (.) in the same expression?
But I understand that we can validate the special character to accept only dot (.) using substring. Therefore, this solution would work anyways.