Chuck D. wrote:
> Pardon me on this, the cat -A report for the failed line (and subsequent
> lines) shows ^M$ within the field, not just $.
>
> I assume that is probably a \r\n and postgres wants \r for field data and \n
> to end a line.
>
> I've tried working this over with sed but can't get the syntax right. I also
> have iconv installed if that would help any. Are there any good tools that
> will tell me what this really is instead of just ^M$ ?
If all you just want to do is strip out the ^M, you can run dos2unix on
it, assuming that you are running a *nix distro.