Re: Load command and characters in field

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. It is merely a new paragraph within the same field. I end up |> with an error message implying that the number of fields in the |> informix file do not equal the number of fields in the Foxpro file. |> It does, but since Informix reads the carriage returns as a new |> record instead of just recogizing the delimiter, it counts wrong. |> Following me? |> |> Does anyone know a way I can work around this problem without |> deleteing all the carriage returns within each field? |> |> Thanks in advance |> |> Bonnie |> weller@zorro.cecer.army.mil One of two ways the first is the dbload utility. This can be used to load any information from any file format given the position ( start and stop ) of the field in the ascii data file. The second ( the method I would use ) would be to use a text formating tool ( awk,sed,... ) to reformat the ascii file. -- ################################################################################ Joseph S. Sellinger No part of this has anything to do with Ford Motor Company and are my views. ################################################################################