Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2008
    Posts
    6

    Unanswered: Removing CR/LF characters during extraction

    I use the following command to extract records from db to a text file:

    db2 -x -tf test.sql -r test.txt > /dev/null 2>&1

    Is there any option that could be used in the above statement to remove CR/LF characters ?

    Appreciate any advice.

    The other alternative I have is to use a replace command in the SQL script.

  2. #2
    Join Date
    Apr 2012
    Posts
    1,034
    Provided Answers: 18
    Are you only interested in the line terminators?(use dos2unix)
    If the CR/LF characters are inside the data values, why do you wish to remove them?

Posting Permissions

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