Recent content by Quinn71

You rock CaKiwi! You rock hard!! Thanks for all your help.

Unfortunately there are multiple ^M's in the file as well as multiple ^M's throughout the same record.

Thanks CaKiwi. I have gone the vi route as well and it does a great job of getting rid of the ^M's. What it does not do is combine the next line with the line that had the ^M on it. Here is an example of my data. Example 1 - This is correct. column1|column2|column3 is a test Example 2 -...

I have unloaded a database table to a pipe “|” delimited file. One of the columns in the table is a large char field. Within that column there are some records where an enter was used to format the field. The unload file shows the enter as a ^M and moves the rest of the column to a separate...