Embedded "carriage returns"

In article <2bc1d1$sn0@max.cecer.army.mil> weller@zorro.cecer.army.mil (Bonnie Weller) writes: >Hi, > >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. ... > >Bonnie >weller@zorro.cecer.army.mil Bonnie, 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? Jeff ---------------------------------------------------------------------------- Jeff Cauhape cauhape@TWG.COM 415/962-7147 Room 226 (SneakerNet) For every complex problem, there is a solution that is simple, neat, and wrong. -- H. L. Mencken ----------------------------------------------------------------------------