Coding to check for duplicate character in a string

[Benjamins via AccessMonster.com]

Hi,

Is there a way for me to check whether is there any duplicate character in a
string.

Example
User Entry Result
"12345" No Duplicate
"ABCDE" No Duplicate
"AACDE" Duplicate
"12341" Duplicate

Thanks

 

[Alex Dybenko]

Hi,
air code to explain the idea:

str="AACDE"
strresult ="No Duplicate"
for I = 1 to len(str)
if instr(0,left(str,I-1) & mid(str, I+1), mid(str, I,1))>0 then
strresult ="Duplicate"
exit for
end if
next I


--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[Benjamins via AccessMonster.com]

Thanks.

Hi,
air code to explain the idea:

str="AACDE"
strresult ="No Duplicate"
for I = 1 to len(str)
if instr(0,left(str,I-1) & mid(str, I+1), mid(str, I,1))>0 then
strresult ="Duplicate"
exit for
end if
next I

Hi,

[quoted text clipped - 10 lines]

Thanks