Removing a Specific Character

Results 1 to 2 of 2

Thread: Removing a Specific Character

  1. #1
    Join Date
    Dec 1969

    Default Removing a Specific Character

    Hi All. Let me see if I can explain this right since its a bit hard to explain<BR><BR>I exported my OUTLOOK contacts into a access database table. Now on the this table there is a memo field called Notes and in this field its where all the notes from my contacts are. Ok I having a problem that some of the data in this field has a weird black square that looks like this * which I think its a line break because it is on the end of each line and because of that I&#039;m getting and error when trying to do a query in ASP. How can I replace that weird blank square (*) with something else?

  2. #2
    Join Date
    Dec 1969

    Default I'm not sure why having those

    in there would cause you query errors. You can use the REPLACE command to replace those characters with vbcrlf or just strip them out. VB Script reference is on the left bar of this page.

Posting Permissions

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