Converting string array to integer array from SQLite

Question

Friends I have created an integer array qlist[] and it has some elements. Now i have inserted this integer array to data base in form of String as

Arrays.toString(qlist)

Now when i get it back again from db in future, I want to convert that string into Integer array .. Eg.

int[] qlist={13,4,12};

in database it looks like

[13,4,12]

as a string.

Follow this stackoverflow.com/a/6347763/1405983

Hardik Joshi
– Hardik Joshi

2013-01-12 07:29:04 +00:00
Commented Jan 12, 2013 at 7:29 — Hardik Joshi
– Hardik Joshi, Commented Jan 12, 2013 at 7:29

Nirav Tukadiya · Accepted Answer · 2013-01-12 07:29:52Z

4

First of all save your String in a string variable.you need to remove [] brackets and then split your string by comma(,).

then you will have an string array containing only 1,2,3 values.you can easly convert them to integer by its position. here i have given the code for it.hope it will help.

String arr = "[1,2]";
 String[] items = arr.replaceAll("\\[", "").replaceAll("\\]", "").split(",");

 int[] results = new int[items.length];

for (int i = 0; i < items.length; i++) {
    try {
       results[i] = Integer.parseInt(items[i]);
    } catch (NumberFormatException nfe) {};
 }

answered Jan 12, 2013 at 7:29

Nirav Tukadiya

3,4271 gold badge20 silver badges36 bronze badges

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

Collectives™ on Stack Overflow

Converting string array to integer array from SQLite

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related