Questions tagged [number-with-delimiter]

10 questions
12
votes
5 answers

Rails: Why is the "number_with_delimiter" method not recognized inside my model?

I have a simple validation: class Product < ActiveRecord::Base # include ActionView::Helpers::NumberHelper ... validates_numericality_of :price, :less_than => 1000000, :message => "must be less than…
Misha Moroshko
  • 166,356
  • 226
  • 505
  • 746
3
votes
2 answers

How to separate a number according to the Indian numbering system in Rails?

I have used number_with_delimiter method for adding commas for numbers in an invoice in Ruby on Rails. But the number format resulted in 23,324,455 and not as 2,33,24,455 that is, Indian Rupees format. <%= number_with_precision(@number, :precision…
2
votes
1 answer

How to add a class to delimiter using rails?

I have added a comma to a large number using the number_with_delimiter call, now I'd like to add a class to the comma. This is my code to get the commas = "#{number_with_delimiter(1000, delimiter: ",")}" I think the code to add the class to the…
1
vote
2 answers

JS Counting Sort with Delimiter

I have a sample of my data with the following array that's currently in the order the result should look like; how would I implement a counting sort to keep this data organized in this form: Organized by the first 4 digits in ascending…
1
vote
1 answer

MySQL LOAD DATA INFILE with special deliminators

I have data that has fields deliminated by \u0001 and records deliminated by \u0002\n. I want to use LOAD DATA INFILE to import all of the data at once into a MySQL database. I know that \u0001 can be written as X'01', but I am not sure how to write…
David
  • 14,205
  • 20
  • 97
  • 144
1
vote
1 answer

Rails number_with_delimiter return integer without delimiter

I'm usually using number_with_delimiter to make my integer or my decimal more easy to read, I have once problem with it when using it inside controller but it solved that time. Now I don't know what happen actually when I just simply put those…
ksugiarto
  • 940
  • 1
  • 17
  • 40
0
votes
3 answers

Scanner isn't reading the last int on each line because of my delimiter

I'm trying to read a simple text file shown below with the Scanner class and have a a delimiter set as scanner.useDelimiter(","); however as you can see there is no comma at the end of each line so the scanner doesn't read the last number on each…
0
votes
2 answers

How to retrieve records using comma separated values with IN clause?

I would like to retrieve certain records from a full list of table. Here I am using comma separated values with IN clause. The table rows looks like this: Here is my SQL query, but the query completed with empty result set` DECLARE @input…
sridharnetha
  • 2,104
  • 8
  • 35
  • 69
0
votes
1 answer

Analysis of Python dataframe where integer column delimited with symbol

Can you please help me to work with column having delimited integer values in python ? How can we create an additional column say "PHR_INSTANTENEOUS_MIN" which stores the minimum value of the numbers in PHR_INSTANTENEOUS. Like in first row : "-18"…
pratyada
  • 49
  • 4
0
votes
0 answers

number_with_precision return Integer

I have a very weird problem with number_with_precision() and number_to_currency(). In my application, they both raise an comparison of String with 0 failed if i do not set :precision But when i try the very same functions in irb, everything is fine…