Can't use search/replace against a .csv to create one long string



  • trying to figure out how to Search/Replace a .csv to remove the carriage return but keep the value and comma

    BEFORE:
    value1,
    value2,
    value3,
    value4,
    etc

    AFTER:
    value1,value2,value3,value4,etc

    Notepad ++ can’t seem to find the character so that I can replace.

    Appreciate the help

    Jeff



  • Hi Jeff Taylor,

    using the replace dialog.
    Set Extended in Search Mode
    Find what: \r\n
    and leave Replace with empty
    press Replace All
    Done

    Cheers
    Claudia


Log in to reply