Conditional replace of first character in string

[lorirobn]

Hi,

How can I replace a semi-colon ( only if it is the first character in my string? Sometimes it will be there, but not always.

Thanks in advance...

 

[snyperx3]

How about this?

If Left(yourString,1) = ";" Then
yourString = replacement & Right(yourString,Len(yourString)-1)
End If

-Pete

 

[lorirobn]

Excellent! Got it - thank you so much! Nice and simple, and it works, too.
Lori

 

[stix4t2]

maybe instead of Right(str, len(str)-1) you can use
mid( str, 2)

 

[lorirobn]

cool!
I love learning all these tricks...