Replace carriage return in csv file

Turn on suggestions. Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type. Showing results for. Search instead for. Did you mean:. All forum topics Previous Next. Go to Solution. CSV file in data step using infile.

Posted AM views. I'm importing some data from the web using an infile statement in a data step. Compress name,'0D0A'x Here's a simplified version of my code that creates a work file but with errors. Accepted Solutions. Re: how to remove carriage return characters from. Posted PM views In reply to popeil Found the answer here, much thanks to Tom!

Posted PM views In reply to Haikuo. Be careful: in Excel you can find both variants. If you import data from a. In case you get. Remove Carriage Returns manually Pros: the fastest way. For example, it is possible to remove carriage returns and then eliminate excess leading and trailing spaces and those between words.

Or you may need to delete carriage returns to use your text as an argument of another function without changing the original cells. Copy the formula across the other cells in the column. Then just press V. Remove the helper column. VBA macro to get rid of line breaks Pros: Being created once, can be reused in any workbook. Wednesday, March 10, AM. Have you tried using the String. Thursday, March 11, PM. Try out this code to replace the new line chars.

Once you have the modified file data you could save to the file. ReadToEnd objReader. Replace Environment. NewLine, "" MsgBox strContents. Thanks guys! I tried using the script above but I kept on getting the same error. The problem here is that one of the columns of my csv file, Notes, is corrupted. It has the quotes wrapped around the column.