trim return caracter

Discussion in 'ASP General' started by Séverine Donnay, Nov 10, 2004.

  1. Hi,

    I make a csv file with values from data base fields . If my value contains a
    carriage return caracter at the end, a new line is created in my csv file. I
    tried to replace chr(13) caracter by an empty caracter but it doesn't work,
    my code is :
    Replace(Trim(element.value), chr(13),"")

    Do you have any idea to resolve my problem ?
    Thanks.

    Severine
    Séverine Donnay, Nov 10, 2004
    #1
    1. Advertising

  2. Try replacing vbCrLf instead of Chr(13).

    Replace(Trim(element.value), vbCrLf,"")

    Ray at work



    "Séverine Donnay" <> wrote in message
    news:DVukd.24682$...
    > Hi,
    >
    > I make a csv file with values from data base fields . If my value contains
    > a
    > carriage return caracter at the end, a new line is created in my csv file.
    > I
    > tried to replace chr(13) caracter by an empty caracter but it doesn't
    > work,
    > my code is :
    > Replace(Trim(element.value), chr(13),"")
    >
    > Do you have any idea to resolve my problem ?
    > Thanks.
    >
    > Severine
    >
    >
    Ray Costanzo [MVP], Nov 10, 2004
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. FAQ server
    Replies:
    0
    Views:
    138
    FAQ server
    Aug 29, 2006
  2. FAQ server
    Replies:
    0
    Views:
    135
    FAQ server
    Oct 26, 2006
  3. FAQ server
    Replies:
    6
    Views:
    213
    Jonas Raoni
    Dec 25, 2006
  4. FAQ server
    Replies:
    26
    Views:
    293
    Dr J R Stockton
    Feb 26, 2007
  5. FAQ server
    Replies:
    2
    Views:
    130
    -Lost
    Apr 24, 2007
Loading...

Share This Page