similar to: Perl CGI scripts - stripping out unwanted carriage returns etc

If I save a dataframe with a character-typed last column to a relational database with dbWriteTable, the values in the last column of the resulting table in the database will have a '\r' (carriage return) appended. If I read back the dataframe with dbReadTable the last column in the resulting dataframe has also '\r' appended (see protocol below). Setting or unsetting sql-mode

Colleagues, I am using R 2.4.0 on both a Mac (10.4.8) and Linux (RedHat 9). To read data from an Excel spreadsheet, I do "save as" in Excel, then select the "Text (tab-delimited)" format. The resulting file uses a tab separator and I can usually read the file using read.delim. Sometimes, the header row contains embedded carriage returns. When I view the file,

I apologize in advance if I'm wasting bandwidth with a simple question, but I was unable to find a solution for this problem in the documentation... I've got a set of shares set up on a SUN Enterprise 5500 using Samba 2.0.4. In Windows NT, I map a drive to the share. When I copy a text file from Windows NT to the SUN, editing the file in UNIX shows that ^M has been added to the end of

Hope this is not too trivial I am reading a large file using scan. In one part of this file there is a chunk of text within which i need to know the positions of line breaks. But scan seems only An example of the file is: " a 0 1 0 bftt 020 cftt T 1 R a 0 1 2 1 2 b 0 1 2 2 2 c 0 10 00 " so precisely i need in the scanned file in R to know where each carriage return is in the file

Dear all, I have a code chunk in my Rnw file that, when executed, outputs carriage return characters ('\r') to inform on the progress (e.g. "sweep 4 of 1024\r"). But Sweave interprets this as a newline character, and therefore I get countless pages of output in my vignette where I only really want one line. Any ideas? Thanks E

It seems like I must be missing something since I haven't been able to find mention of this. Under Windows 7 I'm not getting carriage returns in the output of BATCH files using 2.15.0 (both 64-bit and 32-bit). They are in the startup messages, but not for the real output. Is this on purpose? Pat -- Patrick Burns pburns at pburns.seanet.com twitter: @portfolioprobe

Hi, jslint doesn''t seem to like the carriage returns in the mapstraction files. Is there a way around this? I didn''t see an option for it. -Mike

From: Christian Hesse <mail at eworm.de> Logging to stderr results in line endings being terminated with carriage return (\r) and new line (\n). While this is fine for terminals it may have undesired effects when running from crond and logging to syslog or similar. I run ssh from cron on an recent linux host. Viewing logs with journalctl I see: Sep 06 16:50:01 linux CROND[152575]: [96B

Hi, I'm hoping someone has a suggestion for handling a simple problem. A client gave me a comma separated value file (call it x.csv) that has an id and name and address for about 25,000 people (25,000 records). I used read.table to read it, but then discovered that there are stray carriage returns on several records. This plays havoc with read.table since it starts a

Guys, Dovecot 1.0.15 [1], just built the latest antispam-plugin 1.2 (tarball) for testing, mailtrain backend for SA integration. Both built from custom spec files. The mail that is being trained is different than its respective source in the mbox file. The trained one shows added, trailing carriage-return chars for all headers, which are not in the headers in the mbox file. This breaks sa-learn

Hi, I have just set up samba v 2.0.0 on solaris, sharing to Win2k, win98 clients. All shares work fine, but users have come up with a problem. If a file (ASCII text) is created on the windows client on the share, when read on the solaris system, ctrlM (^M) characters appear in place of the carriage returns. How can I prevent carriage return from being replaced by ctrlM (^M). I reckon this is

I have a comma separated data file with no carriage returns and what I'd like to do is 1. read the data as a block text 2. search for the string that starts each record "record_start", and replace this with a carriage return. Replace will do, or just add a carriage return before it. The string is the same for each record, but it is enclosed in double quote marks in the file.

Having problems with the write.table function. I can write a tab delimited file just fine, but for each line in my matrix its inputs a carriage return when i dont want it to. For example my matrix might be: ID V1 V2 V3 FARY1004 1 2 3 FARY2067 2 3 1 FARY4587 2 2 2 And I want the written File to be: FARY1004 1 2 3FARY2067 2 3 1FARY4587 2 2 2 TIA -- View this

Hi there, does anybody know how can I avoid the DOS-style end of line (LF + CR) when saving a shared Unix ASCII file through Samba ? Should I use the "magic script" (but I really didn't understand how it works) or is there any way to do this dos2unix-like conversion automatically (I can't find the right parameter for smb.conf)? Thanks Gianni -- Gianni Ferrari

Hi all, I imported a file (in CSV format) into R for processing, then imported the result into MySQL. However, there are *carriage return* characters (hexadecimal: *0D*) that are appended to the characters in the last field of the table. i.e *\r* appended to the character values (as shown below) Before importing into MySQL: asdf After importing into MySQL: asdf*\r* ** ** Are there any options

Hi, I was able to rsync files from Windows 2000 to Solaris 8 but when I opened the text files with vi on solaris, a '^M' char was appended to each line of the files. My question is how to get rid of that '^M' when rsync'ing ? I suspect this is because Windows and Unix treat line feed/carriage return differently, but I just do not want that '^M' shown in the files after

Hi, I've checked all the docs I can find and this top icisn't mentioned, so I'm guessing there is no such thing, but I have users who swear that VisionFS used to automatically convert unix text files to windows text files (change the EOL to have both a carriage return and a newline, instead of just a newline). I think the user is mistaken, but just wanted to check. Is there a way

I'm trying to get perl CGI programs to work from the cgi-bin (actually a sub-directory cgi-bin/various) and have set appropriate permissions using chmod 755. I'm currently testing using the simplest cgi program, you know the one: #!/usr/bin/perl # howdy--the easiest of CGI programs use CGI; print <<END_of_Multiline_Text; Content-type: text/html <HTML> <HEAD>

Hi, and thanks in advance for your time. Background - I am working on a package and wish to have a routine's progress reported. The routine can take some time, and I would like to inform the user about the routine's progress. I have scoured the archives but to no avail, so would like to solicit input from this list. I am successfully using cat("\rBootstrap replication ", i,

Hi, I was trying to get Google Calendar to import a gem-generated file with no luck (it kept giving me the unhelpful message "parse error," even though http://severinghaus.org/projects/icv/ accepted the file as valid). After a bunch of screwing around, I changed line 148 of component.rb to include a .gsub("\r", "\\r"), which fixed the problem. It seems like line