Results 1 to 2 of 2

Thread: trimming

  1. #1
    Join Date
    Dec 1969

    Default trimming

    this is what i have<BR>Alice W<BR>I need to get to this<BR>alicew<BR>I want to use a trim function or something of that nature. Is this possible? I am attampting to put these together to call an html page, i.e.<BR>&#060;a href="alicew.html"&#062;&#060;/a&#062;<BR>If more info is needed please let me know, thanks

  2. #2
    Join Date
    Dec 1969

    Default RE: trimming

    You could use the REPLACE() function to remove the space between first name and last initial. You could alse use the LCASE() function to convert to lowercase. Here is an example:<BR><BR>Function FormatText(sText)<BR> sReturn = LCASE(Replace(sText, " ", ""))<BR><BR> FormatText = sReturn<BR>End Function<BR><BR>Hope this helps!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts