[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 181
  • Last Modified:

how do you take a char out of a string

how do i remove the @ from @hello in a string please


thanks ever so much

so "@hello" becomes "hello"

0
Johnny
Asked:
Johnny
  • 6
  • 6
  • 2
1 Solution
 
ColosseoCommented:
Hi again Pern

you could use code similar to this

str_Test = "@hello"

str_Test =replace(str_Test,"@","")

HTH

Scott
0
 
ColosseoCommented:
or another example if it is always the first character you want to strip off you can use

str_Test = "@hello"

str_Test = mid(str_Test,2)

Regards

Scott
0
 
David LeeCommented:
NewString = Replace("@hello", "@", "")
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
David LeeCommented:
Colosseo types faster!
0
 
ColosseoCommented:
and if @hello is in a string of other words...

str_Test = "other words @hello around hello"

str_Test =replace(str_Test,"@hello","hello")

Scott

- BlueDevilFan -- Colosseo has nothing better to do :)
0
 
JohnnyAuthor Commented:
wlist.text="@hello"

WList.Text = Mid(WList.Text, 2)

i get a blank WList.Text when i try to do this anyhelp?
0
 
ColosseoCommented:
Hi pern what kind of object is wlist?
0
 
JohnnyAuthor Commented:
a listbox
0
 
JohnnyAuthor Commented:
hahaha that did it i just didnt make it save itsself

NewString= Mid(WList.Text, 2)

and that works perfectly

thanks alot heres your points again
0
 
JohnnyAuthor Commented:
side note is there a way to update the listbox esaly with out repopulating it with the take out @?
0
 
ColosseoCommented:
Hi pern glad its working :)

You could try code like this to loop through all items in the listbox

if the item starts with an @ then the @ is stripped off

For i = 0 To WList.ListCount - 1
  If Left(WList.List(i), 1) = "@" Then WList.List(i) = Mid(WList.List(i), 2)
Next

Hope that works for you mate

Thanks for the grade

Scott
0
 
JohnnyAuthor Commented:
it would have to match the one we striped and leave the rest as is
0
 
ColosseoCommented:
well using the code above

@hello
hello
test
@test

would return

hello
hello
test
test

but it could be changed to only affect @hello

so for it to return

hello
hello
test
@test

For i = 0 To WList.ListCount - 1
  If WList.List(i) = "@hello" Then WList.List(i) = Mid(WList.List(i), 2)
Next

Hope thats what you meant

Cheers

Scott

0
 
JohnnyAuthor Commented:
thats right listboxes are sorta like arrays im stupid i should known that..guess im code burnt...rain always makes me tired and its pouring here

i also made the code change just the var i wanted and sent it via the newstring worked great

yes thats what i wanted thanks alot

0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 6
  • 6
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now