Not sure if this will help, but I have had issues with windows file in Unix before and this has worked for me…
To remove the ^M characters at the end of all lines in vi, use: :%s/^V^M//g The ^v is a CONTROL-V character and ^m is a CONTROL-M. When you type this, it will look like this: :%s/^M//g Rafael From: Tyler Hobbs [mailto:ty...@datastax.com] Sent: Tuesday, March 24, 2015 5:55 PM To: user@cassandra.apache.org Subject: Re: error in bulk loading On Tue, Mar 24, 2015 at 5:30 AM, Rahul Bhardwaj <rahul.bhard...@indiamart.com<mailto:rahul.bhard...@indiamart.com>> wrote: I need to import a csv file to a table using copy command, but file contains carriage returns which causing me problem in doing so, Is there any way in cassandra to solve this You can surround the field with double-quotes to handle this (or change the quote character with the QUOTE option for COPY). -- Tyler Hobbs DataStax<http://datastax.com/> ________________________________ This E-mail and any of its attachments may contain Time Warner Cable proprietary information, which is privileged, confidential, or subject to copyright belonging to Time Warner Cable. This E-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this E-mail, you are hereby notified that any dissemination, distribution, copying, or action taken in relation to the contents of and attachments to this E-mail is strictly prohibited and may be unlawful. If you have received this E-mail in error, please notify the sender immediately and permanently delete the original and any copy of this E-mail and any printout.
