Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

<b>Removing the trailing semicolon</b> 1

Status
Not open for further replies.

mashaguen

Programmer
May 31, 2001
6
0
0
US
How do I remove the trailing semicolon?

My results prints out: general, 3/47:31; 4/11:45;
I need it to print out: general, 3/47:31; 4/11:45
without the semicolon on the end.

Any sugestions?

Thanks I would appreciate any help
 
Count the number of characters in the string with:
stringnumber = Len("stringname")

Then you can define the printnumber:
printnumber = stringnumber - 1

Then use the left-function:
Left(stringname, printnumber)

Hope this will help you,
Erik
 
or an easier way would be

left(stringname,len(stringname)-1)

-Jas
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top