Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need a help for the below scenario where need to identify the presence of repeated Alphabets/Numbers in the given string which can be considered as error.
Example:
AAAAAA,999,0000
If(ID=Repeat(Left(ID,1),Len(ID)),'INVALID','VALID')
Hi @khadar,
When you said repeated then it supposes to continue like "AAAA" or "ABCA" also treated as an error.
can you please elaborate on what exactly constitutes an error, best with some more examples for both error and no error.
thanks
Marco
Thank you for looking into my help.
I need to check the single value (ID) which is continues reapeating through out length of whole string and does not contain any other values except the repeating one and should be identitfied as IN VALID like below.
Example:
ID | Status | |
AAAAAAA | IN VALID | |
44444 | IN VALID | |
CCCCC | IN VALID | |
GTH873521 | VALID | |
TY43ERYD76 | VALID | |
AAATUTR55799 | VALID | |
Hi @khadar,
Please check with the below expression if that works for you.
=if(Left(ID,1)=right(ID,1),'IN VALID','VALID')
If(ID=Repeat(Left(ID,1),Len(ID)),'INVALID','VALID')
or slightly shorter:
If(ID=KeepChar(ID,Left(ID,1)),'INVALID','VALID')