in reply to Re^3: Compare and group unmatched records from 2 CSV files together
in thread Compare and group unmatched records from 2 CSV files together

And it will remove \r also when correctly quoted:

code,value
1,"abc\rdef"

[download]

Is valid CSV (binary => 1 needed for Text::CSV and Text::CSV_XS), but will change content with that change. Not good!


Enjoy, Have FUN! H.Merijn

Replies are listed 'Best First'.
Re^5: Compare and group unmatched records from 2 CSV files together
by Laurent_R (Canon) on Jun 25, 2014 at 17:20 UTC
    Not quite sure to understand what the point is. I just know that I used to have a regex like this: 
    s/\r\n/\n/

    [download]
    or even: 
    s/\r\n$/\n/

    [download]
    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//g

    [download]
    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.
[reply]
[d/l]
[select]

In Section Seekers of Perl Wisdom