Regex in java code for comma separated strings surrounded with single quotes

Question

I want to generate a regular expression for extracting string tokens from comma separated tokens surrounded with single quotes.

For example: 'ad2&fs'df','sdfsg34fb5bg','rfrg#d,fg'

Here, I want to get the following tokens:

ad2&fs'df
sdfsg34fb5bg
rfrg#d,fg

The tokens can contain alphabets, numbers and special characters including comma and apostrophe (single quote).

possible duplicate of [How to split a string in Java](http://stackoverflow.com/questions/3481828/how-to-split-a-string-in-java) — RealSkeptic, Sep 15 '15 at 08:32
I had tried many expressions but it got very complex and did not work — Amrita, Sep 16 '15 at 06:09

score 0 · Answer 1 · answered Sep 15 '15 at 08:29

This could will help.

public static void main(String args[]) throws Exception {
    String s=  "'ad2&fs'df','sdfsg34fb5bg','rfrg#d,fg'";
    System.out.println(Arrays.toString(s.split("','|^'|'$")));
}

O/P :

[, ad2&fs'df, sdfsg34fb5bg, rfrg#d,fg]

This code will give you an additional empty String at index 0 because of the first '. You could just ignore it

score 0 · Answer 2 · answered Sep 15 '15 at 10:52

0

//use this simple regex pattern

public static void main(String[] args) {

    String s = "'ad2&fs'df','sdfsg34fb5bg','rfrg#d,fg'";
    Pattern pattern = Pattern.compile("'(.*)','(.*)','(.*)'");
    Matcher matcher = pattern.matcher(s);
    boolean match = matcher.matches();

    System.out.println(matcher.group(1));
    System.out.println(matcher.group(2));
    System.out.println(matcher.group(3));
}

}

Output is as follows

ad2&fs'df

sdfsg34fb5bg

rfrg#d,fg

hope this helps.

answered Sep 15 '15 at 10:52

james jelo4kul

839
4
17

It can have any number of tokens not necessarily three – Amrita Sep 16 '15 at 06:08
Pattern pattern = Pattern.compile("('(.*)','(.*)','(.*)')*?"); would enable you get more tokens. Hope this helps – james jelo4kul Sep 16 '15 at 14:11

Regex in java code for comma separated strings surrounded with single quotes

2 Answers2