Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2002
    Posts
    2

    Unanswered: sed to remove carriage return

    hi,
    i am using utl_file to insert data into tables . the data file is read terminated by |,| .but the procedure exits as the data file has line feeds in between. is there a way of removing these line feeds.

    for example |,|. MDA
    . Candidate must be able to cover the geographic areas of Orlando, Gainesville, Daytona and Jacksonville, FL and overnight travel approximately 20 25%.

    Thanks in advance

  2. #2
    Join Date
    Apr 2002
    Location
    California, USA
    Posts
    482

    Cool

    in vi you can do that with

    :1,$s/,//g

    sed is using similar commands.

    let me know if you need more help

    clio_usa

Posting Permissions

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