![]() |
| |||||||
| Sponsored Links |
![]() |
| | LinkBack | Thread Tools | Display Modes |
|
#1
| |||
| |||
| Hi, I have a variable called str=", Hello How are you" I want to remove the comma at the start of the string I tried Len and LTrim but it didnt work out any idea todd |
| Sponsored Links |
|
#2
| ||||
| ||||
| Code: Dim str str = ", Hello how are you" str = Right(str, Len(str) - 2)
__________________ jmurrayhead If you agree with me... click the icon! If my post solved your problem, click the button in the lower right-hand corner of the post.If you like it here...throw us a few bones to help support us. Join our Folding team: DeveloperBarn Folding |
|
#3
| ||||
| ||||
| will there always be a comma at the beginning of the string? ... if not, try this Code: if inStr(str, ",") = 1 then
str = trim(mid(str,2,len(str)))
end if
__________________ Quote of the Month: Quality: The race for quality has no finish line- so technically, it's more like a death march. Questions to Ponder: What do you do when you see an endangered animal eating an endangered plant? iif([sarcasm]=true,iif([you have to ask]=true,"didn't work","ha ha ha"),"not sarcasm") copyright © 2008 sbenj69 Last edited by mehere; May 8th, 2008 at 01:31 PM. |
![]() |
|
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|