in reply to Re^4: Compare and group unmatched records from 2 CSV files together
in thread Compare and group unmatched records from 2 CSV files together
or even:s/\r\n/\n/
but it turned our to insufficient, because the input data sometimes had line ending with "\r\r\n" and sometimes also "\r" in the middle of the line, generating all kinds of probblem. In the end, this regex:s/\r\n$/\n/
turned out to solve all the problems. Now, of course, it depends on what your input data is and what you need at the end of the day. With different data and different goals, the regex would probably have to be changed. But that's not hot news, if you need to do data munging, the first prerequisite is to know your data well.s/\r//g
|
|---|