How to Remove String

J

jothis

Active Member

Licensed User

• Jun 18, 2010

• #1

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

N

nicolasWhite

Member

• Jun 18, 2010

• #2

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.

 

J

jothis

Active Member

Licensed User

• Jun 18, 2010

• #3

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:

 

N

nicolasWhite

Member

• Jun 18, 2010

• #4

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