Obscure issue with string formatting from SQLite database

Question

I appreciate there's a lot of helpful stack questions and answers to my question but I'm running into problems I've not had in the past.

The Problem:

I am using a cursor to populate textviews in rows on a view (without using listview - that's crazy I know). I am trying to format the string value(s) taken from from the database column STUDENT_POINTS that are put into a textview tpoints. Here is the code I am using:

public void bindView(View v, final Context context, Cursor c) {
        final int id = c.getInt(c.getColumnIndex(Students.STUDENT_ID));
        final String name = c.getString(c.getColumnIndex(Students.STUDENT_NAME));
        final String age = c.getString(c.getColumnIndex(Students.STUDENT_AGE));
        final String points = c.getString(c.getColumnIndex(Students.STUDENT_POINTS));
        final String teachernote = c.getString(c.getColumnIndex(Students.TEACHERNOTE));
        final byte[] image = c.getBlob(c.getColumnIndex(Students.IMAGE));
        ImageView iv = (ImageView) v.findViewById(R.id.photo);

        if (image != null) {
            if (image.length > 3) {
                iv.setImageBitmap(BitmapFactory.decodeByteArray(image, 0,image.length));
            }
        }

        TextView tname = (TextView) v.findViewById(R.id.name);
        tname.setText(name);
        TextView tage = (TextView) v.findViewById(R.id.age);
        tage.setText(age);
        TextView tpoints = (TextView) v.findViewById(R.id.points);
        tpoints.setText(String.format(points, "%1$,.2f"));

        final StudentsConnector sqlCon = new StudentsConnector(context);

The rest of bindView is for buttons so I have not included it here. The problem is with the line:

tpoints.setText(String.format(points, "%1$,.2f"));

I'm intending to have commas to separate out large numbers but this does nothing! If anybody has the time could you please tell me what I'm doing wrong?

Thanks in advance.

What is a sample of what Students.STUDENT_POINTS contains?

HalR
– HalR

2013-04-18 23:22:39 +00:00
Commented Apr 18, 2013 at 23:22 — HalR
– HalR, Commented Apr 18, 2013 at 23:22
It contains numbers saved as a string.

Drakora
– Drakora

2013-04-18 23:37:53 +00:00
Commented Apr 18, 2013 at 23:37 — Drakora
– Drakora, Commented Apr 18, 2013 at 23:37

HalR · Accepted Answer · 2013-04-19 01:04:07Z

1

You have your two parameters backwards-- you should have the format string followed by the data string: String.format("%1$,.2f", points );

This formatted nicely for me with this little snippet in my code:

    double points = 56789.45f;
    String boogie = String.format("%1$,.2f", points );

and it generated a number 56,789.45 But bigger numbers don't work well due to precision in the formater. You may want to split the mantissa off of their, format them separately and combine them.

edited Apr 19, 2013 at 1:04

answered Apr 19, 2013 at 0:27

HalR

11.1k5 gold badges51 silver badges86 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Drakora Over a year ago

Thanks for the response, HalR. I've have tried it with the parameters reversed and it results in a force close. Perhaps converting the string to a double first might work? - I'm going to give that a go and let you know how I get on. If this doesn't work, I might have to try saving my database value as an integer/double.

HalR Over a year ago

It seemed to be very finicky for me. Like a number 32343.434 would force close for me too. I really think that if you broke it into two parts, it would format more easily. I'll edit my post with my suggestion

Drakora Over a year ago

I haven't had any success :/ Thanks for your answer, it of course works in most cases but I suspect I'm having trouble because of my setup in general. I'll tick it off as this would suit most cases if people were to come across this question.

Collectives™ on Stack Overflow

Obscure issue with string formatting from SQLite database

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related