trim help

Results 1 to 2 of 2

Thread: trim help

  1. #1
    Join Date
    Dec 1969

    Default trim help

    I have a field in a database which holds a Joe Bloggs<BR><BR>I have pulled this field down but need to somehow search for the space between first name and surname replace it with a . and then add to the end...<BR><BR>could someone help me with this..I guess i use trim? but not sure how..<BR><BR>thanks so much

  2. #2
    Join Date
    Dec 1969

    Default RE: trim help

    Can&#039;t you just do:<BR><BR>myName = "Joe Bloggs"<BR>myEmail = Replace(MyName, " ", ".") & ""<BR><BR>??<BR><BR>Craig.

Posting Permissions

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