similar to: Fwd: Read a Number column with leading zeros using Roo gem

Displaying 20 results from an estimated 200 matches similar to: "Fwd: Read a Number column with leading zeros using Roo gem"

2012 Aug 24
3
ActiveRecord storing arrays and hashes
Hi, When trying to store a Array or Hash to a string field, ActiveRecord automatically serializes them to yaml. If that''s so why is there a special option called serialize? -- Azhagu Selvan http://tamizhgeek.in -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to
2008 Sep 08
1
Roo gem installation fail
hi I am tried to install roo gem 1.2.0 but it gives me following error. It seems it require stdio.h which is not present. Can you please help me how to install roo gem checking for stdio.h... no *** extconf.rb failed *** Could not create Makefile due to some reason, probably lack of necessary libraries and/or headers. Check the mkmf.log file for more details. You may need configuration
2011 Feb 02
1
Roo gem performance problems
I am getting unacceptable performace problems by using the roo gem for reading a file by using XLSX or XLS library from this gem. Someone may suggest me an alternative about how to parse an .XLSX file? <code> parsed_file = Excel.new(filename,false, :ignore) if (file_format.upcase == "XLS") parsed_file = Excelx.new(filename,false, :ignore) if (file_format.upcase ==
2009 May 05
0
How to write data into excel files using roo
Hai, I am using parseexcel to export data to a excel,while exporting a large amount of data it shows a MaxSizeError. Ithink that i will use roo for exporting data into excel.But i dont know the codings to write data into excel can anyone help me.. Thanks in Advance -- Posted via http://www.ruby-forum.com/.
2013 Oct 21
3
What it exactly do these do ( RubyXL::Parser.parse and Roo::Excelx.new) when opening a file?
Do they open a file and load it into memory? I''m asking because it seems to take a long time opening a file but after it opens looping into the variable is REALLY fast, could someone explain me or tell me where can I find an explanaition on how this sort of things work? -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk"
2010 Oct 07
2
Truncating leading zeros in strings
I am new to R. I thing this will be simple, but I don't yet know my way around. I am generating character strings from the system clock that represent integers, and I want to convert them to integer values. Strtoi works well, except when there are leading zeros on the string. Could anyone suggest a way to remove those leading zeros? Thanks Paul -- E. Paul Wileyto, Ph.D.
2005 Jul 10
3
not supressing leading zeros when reading a table?
Dear R list, I have a dataset with a column which should be read as character, like this: name surname answer 1 xx yyy "00100" 2 rrr hhh "01" When reading this dataset with read.table, I get 1 xx yyy 100 2 rrr hhh 1 The string column consists in answers to multiple choice questions, not all having the same number of answers. I could format the
2012 May 22
3
pad leading zeros in front of strings
Dear All, This question sounds very simple but I don't know where I am wrong. I just want to pad leading zeros in some string, for example, "123" becomes "00123". What is wrong if I do following? > sprintf("%05s", "123") [1] " 123" It didn't return "00123", instead it padded with 'blank'. Thank you for your help
2011 Aug 19
4
Leading zeros
An embedded and charset-unspecified text was scrubbed... Name: n?o dispon?vel URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20110819/e7764da5/attachment.pl>
2010 Dec 21
4
Keeping Leading Zeros, Treating numbers as text
Hello, I have a data set, with some numerical values, some non-numerical data, my issue is that I need to preserve my ID numbers (numerics) with the leading zeros, but when I import the data into R (it's in .csv format) using the read.csv(" ") command, it turns all the ID numbers (Example: 00210) into numbers, removing the leading zeros, so I end up with 210. I tried using the
2011 Jul 19
0
Setting up omniauth with salesforce login in rails 2.3.8( ruby 1.8.6)
Hi, We have a production rails app running on ruby 1.8.6 with rails version 2.3.8. We are thinking about setting up omniauth to allow users login through salesforce. But the omaniauth ldap dependency inturn depends on ruby 1.8.7. Is there any way we can setup ominauth without ldap dependency to work on ruby 1.8.6? -- Azhagu Selvan SP -- You received this message because you are subscribed
2009 Oct 17
2
New issue with a New Vista Client - couldn't find service
Running a samba server version 3.0.7 on a FreeBSD box Life has been fine with XP and so forth I added a new vista workstation to my small network Vista found my shares and I am able to access them with no jerking around with authentication types or such as I use appropriate pw and user name to log into the vista box. Problem is vista is spamming my server, taking up >50% cpu
2009 Oct 26
3
changing kickoff time
Hello everybody, we moved our samba server to a new machine. This included changing the samba version from 3.024 to 3.4.2 and changing the OS from Linux to Opensolaris. Samba was compiled from scratch. Passdb Backend is tdb. After the upgrade everything works fine......except: Some users can not login, due to an expired account. Further investigation showed that the "Kickoff Time"
2008 Dec 10
1
Re: Importing / Parsing Large Excel Files ?
Hello, On 16 Okt., 20:02, "AN@S" <anas.marr...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > Hello, > > I''m running into a project where a client has large Excel files > (60.000+ records per file) and he needs an application to import them > into a database to use this data for useful operations (reporting, > calculations .. etc). > > I know
2001 Dec 15
1
Understanding backup-dir semantics
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Please cc in replies as I am not subscrubed to the list - However I have just searched backwards over the list archive looking for an answer and I can't find any posts relating to this. I am currently backing up my family's windows machine over the network to my linux box by mounting the windows disk as a file share an using cp to copy
2013 Oct 04
8
is there any way to convert .xlsx to .xls
Hello Guys, does anybody know if there''s anyway to upload a .xlsx file and then convert it to .xls file for later processing? i''d like to use spreadsheet to write a new xls file but it doesn''t support xlsx and the file is only importable with that format sadly. I saw roo but I don''t know if there''s a direct way to do it. -- You received this
2013 Jul 23
0
percent correctly predicted (PCP) zeros for hurdle model
Hello all, I am using the hurdle model for fitting my count data using the pscl package which is working fine. However, I am stuck with the problem of calculating the percent correctly predicted (PCP) zeros for hurdle model. The method I am trying to use to achieve this is 'hitmiss' in the pscl package (ref: http://www.inside-r.org/packages/cran/pscl/docs/hitmiss). When I do: >
2011 Jun 29
0
customer segmentation using a large data with many zeros
Hi, I am looking for clustering techniques that are tolerant to large datasets (500,000 unique customers with transaction records). I basically would like to conduct customer segmentation based on their transaction history - what they bought, how often they visited stores, demographics etc. And transaction part of the data is binary: 1 if they bought, let's say, fruits etc. Now the problem
2002 Mar 26
1
Block of unwanted zeros in a dest file
I'm syncing from a linux box (NAS disk) to a sun (NAS disk). I just found a file on the destination sun with zeros from bytes 8192 to 32767. (the source file had lots of 'good' random bytes). The rest of the file compares properly. Repeatedly running rsync to send the file didn't fix it. I ran a -c transfer (checksum) and it fixed the file. I'm using 2.5.3 on both sides with
2003 Mar 14
1
Formatting significant digits with trailing zeros
I need a function like signif(), but returns the rounded values as character strings, formatted with trailing zeros where appropriate. If anyone has one, I would sure appreciate a copy. Thanks -Don Details: signif() rounds a number to a specified number of significant digits, for example: > x <- c(2.503,2.477,0.1204) > signif(x[1],3) [1] 2.5 > signif(x[2],3) [1] 2.48