topic Re: Repeated values in string in App Development

Repeated values in string

khadar — Mon, 29 Nov 2021 12:18:26 GMT

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

Re: Repeated values in string

abhijitnalekar — Mon, 29 Nov 2021 12:38:52 GMT

Hi @khadar,

When you said repeated then it supposes to continue like "AAAA" or "ABCA" also treated as an error.

Re: Repeated values in string

MarcoWedel — Mon, 29 Nov 2021 17:13:57 GMT

can you please elaborate on what exactly constitutes an error, best with some more examples for both error and no error.

thanks

Marco

Re: Repeated values in string

khadar — Tue, 30 Nov 2021 04:32:40 GMT

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

Re: Repeated values in string

abhijitnalekar — Tue, 30 Nov 2021 06:35:31 GMT

Hi @khadar,

Please check with the below expression if that works for you.

=if(Left(ID,1)=right(ID,1),'IN VALID','VALID')

Re: Repeated values in string

MarcoWedel — Tue, 30 Nov 2021 12:10:09 GMT

If(ID=Repeat(Left(ID,1),Len(ID)),'INVALID','VALID')

Re: Repeated values in string

MarcoWedel — Thu, 16 Dec 2021 17:40:03 GMT

or slightly shorter:

If(ID=KeepChar(ID,Left(ID,1)),'INVALID','VALID')