Question
Carelon Global Solutions Pvt Ltd
IN
Last activity: 24 Dec 2021 2:11 EST
Requiried Validation for below conditions
My requirement is
1.It need to accept some conditions like
ex:123,456,789
2.For every three numbers it needs separated by (,).
3.It needs through error when user enters special characters.
ex:123,@13,12#
4.it needs to through error in conditions like
ex:123456,123
@#$,123
ING Nederland
NL
@AnilKumarReddyT Please have a look at following post, I believe it is similar one
ING Nederland
NL
@AnilKumarReddyTnot sure how you were testing but here is what I have seen. I have used the following function in a data transform/activity in the source and result is a boolean value (true/false)
@String.pxContainsViaRegex(Param.inpiut,"^[0-9]{3}[\\,][0-9]{3}[\\,][0-9]{3}",false)
Input Result
12345,898 false
123,@13,12# false
123,456,789 true
Updated: 24 Dec 2021 2:06 EST
ING Nederland
NL
Hi @AnilKumarReddyT, can you try using this and share if this meets your expectations:
pxContainsViaRegex(Param.YourString,"\\d{1,3}(?:,\\d{3})*",false)
Thanks,
Saurabh.