How to Remove String

jothis

Active Member
Licensed User
Hi Friends

Here Is My Program Here Iwant Add A user Count.
I used The Substring Function. But I thing Here It Is Not Possible Because Of Ther User Name.

Please Help Me To Remove Strings

Jothis
:sign0085:
 

Attachments

  • test.zip
    1.3 KB · Views: 174
If you want to remove letters and leave only a number then :

userName = "userName1"
Number = substring(userName,StrLength(userName)-1,1)

in case the total number of users is 0 to 9.
 

jothis

Active Member
Licensed User
But I want to add more than 2000

Thankyou for helping me nicolaswhite
Iused it But
'''Number = SubString(userName,StrLength(userName)-2,2)''
Here I want to add more than 2000 counts
like

arun1 to arun 2000
user1 to user 2000

Can you Please Help me?

jothis
:sign0085:
 
userName = "UserName2500"
uNumber = substring(userName,StrLength((userName)-4,4)
i = 0
Do
If Not (IsDigit(StrAt(uNumber,0))) Then
uNumber = StrRemove(uNumber,0,1)
End If
i = i +1
Loop Until i = 3
 
Top