Embedded "carriage returns" 
Author Message
 Embedded "carriage returns"



>I am trying quite unsuccessfully to load a file that was originally a
>Foxpro file into Informix.  The problem is most of the Foxpro fields
>were memo fields with lots of carriage returns.  It appears that
>Informix sees these carriage returns as a new record which is not the
>case.  ...



    Here's an idea for what it's worth:

    The "carriage returns" are probably not the ASCII CR character, but
the ASCII NL (new-line). The default for most UNIX systems is to store
the NL character in the file, and then add the CR character to the output
stream when the file is sent to stdout (the screen).

    What you might do is to use the tr(1) utility to translate the NL
characters to CR (carriage return) characters, and _then_ do the load.
Then when you output your text you will need to do the reverse process,
or change you stty settings to add NL when CR is encountered.

    Clear as mud?



      For every complex problem, there is a solution that is simple,
      neat, and wrong.

                -- H. L. Mencken  

Wed, 24 Apr 1996 05:47:02 GMT
 [ 1 post ] 

 Relevant Pages 

1. max of ("...","...","..")

2. Carriage Return vs. no Carriage Return

3. Embedded Carriage Returns (hex 0d)

4. dr("field").toString returns "400.0000" instead of "400"

5. Compiere "embedded transactions"

6. Error with carriage returns embedded in PL/SQL code blocks

7. SQL*Loader with Embedded carriage returns

8. Do "imp", "exp", and "sqlplus" return status?

9. Do "imp", "exp", and "sqlplus" return status?

10. How To: Embed Carriage Returns in TEXT datatype column

11. Universe/Pick embedded "TRANS"question

12. APPEND FROM problem embedded ""s

Powered by phpBB® Forum Software