Parsing comma separated string with prefix

Question

I am getting comma sepeated string in below format:

String codeList1 = "abc,pqr,100101,P101001,R108972";

or

String codeList2 = "mno, 100101,108972";

Expected Result : Check if code is numeric after removing first alphabet. If yes, remove prefix and return. If no, still return the code.

codeList1 = "abc,pqr,100101,101001,108972";

or

codeList2 = "mno, 100101,108972";

As you can see, I can get codes (P101001 or 101001) and (R108972 ,108972) format. There is will be only one prefix only.

If I am getting(P101001), I want to remove 'P' prefix and return number 101001.

If I am getting 101001, do nothing.

Below is the working code. But is there any easier or more efficient way of achieving this. Please help

for (String code : codeList.split(",")) {
   if(StringUtils.isNumeric(code)) {
        codes.add(code);
   } else if(StringUtils.isNumeric(code.substring(1))) {
        codes.add(Integer.toString(Integer.parseInt(code.substring(1))));
   } else {
        codes.add(code);
     }
   }

According to your question,do you want to also add data like abc? what is else used for? — flyingfox
– flyingfox, Commented Jul 19, 2018 at 11:36
I want to add add the codes. If single alphabet prefix found , remove it and add remaining — Manan Kapoor
– Manan Kapoor, Commented Jul 19, 2018 at 11:40

Youcef LAIDANI · Accepted Answer · 2018-07-19 13:36:05Z

2

If you want to remove prefixes from the numbers you can easilly use :

String[] codes = {"abc,pqr,100101,P101001,R108972", "mno, 100101,108972"};
for (String code : codes){
    System.out.println(
            code.replaceAll("\\b[A-Z](\\d+)\\b", "$1")
    );
}

Outputs

abc,pqr,100101,101001,108972
mno, 100101,108972

If you are using Java 8+, and want to extract only the numbers, you can just use :

String codeList1 = "abc,pqr,100101,P101001,R108972";
List<Integer> results = Arrays.stream(codeList1.split("\\D")) //split with non degits
        .filter(c -> !c.isEmpty())                            //get only non empty results
        .map(Integer::valueOf)                                //convert string to Integer
        .collect(Collectors.toList());                        //collect to results to list

Outputs

100101
101001
108972

edited Jul 19, 2018 at 13:36

answered Jul 19, 2018 at 11:28

Youcef LAIDANI

60.3k21 gold badges111 silver badges178 bronze badges

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

7 Comments

flyingfox Over a year ago

Do you know what is codes.add(code); used for in OP's question? I think he is also want to add pure string like abc

Youcef LAIDANI Over a year ago

@lucumt It is unclear what OP result should be, I will wait the OP to answer my comment in top!

Manan Kapoor Over a year ago

Thanks for your response. it seems to be more cleaner approach. Thanks...

Manan Kapoor Over a year ago

one thing, I was testing the scenarios and for this code (abc15), it is not working. it is removing the c and giving result as ab15. Can we handle this?? I only want to remove prefix if one alphabet is coming

Youcef LAIDANI Over a year ago

@MananKapoor are you sure? check the demo link it return abc15 for abc15 !!

|

flyingfox · Accepted Answer · 2018-07-19 11:59:45Z

2

You can use regex to do it

  String str = "abc,pqr,100101,P101001,R108972";
  String regex = ",?[a-zA-Z]{0,}(\\d+)";
  Pattern pattern = Pattern.compile(regex);
  Matcher matcher = pattern.matcher(str);
  while(matcher.find()){
      System.out.println(matcher.group(1));
  }

Output

100101
101001
108972

Updated：
For your comment(I want to add add the codes. If single alphabet prefix found , remove it and add remaining ),you can use below code:

String str = "abc,pqr,100101,P101001,R108972";
String regex = "(?=,?)[a-zA-Z]{0,}(?=\\d+)|\\s";// \\s is used to remove space
String[] strs = str.replaceAll(regex,"").split(",");

Output:

abc
pqr
100101
101001
108972

edited Jul 19, 2018 at 11:59

answered Jul 19, 2018 at 11:28

flyingfox

13.5k4 gold badges30 silver badges43 bronze badges

Comments

Tim Biegeleisen · Accepted Answer · 2018-07-19 11:27:11Z

1

How about this:

String codeList1 = "abc,pqr,100101,P101001,R108972";
String[] codes = codeList1.split(",");

for (String code : codes) {
    if (code.matches("[A-Z]?\\d{6}")) {
        String codeF = code.replaceAll("[A-Z]+", "");
        System.out.println(codeF);
    }
}

100101
101001
108972

Demo

answered Jul 19, 2018 at 11:27

Tim Biegeleisen

526k32 gold badges324 silver badges399 bronze badges

Collectives™ on Stack Overflow

Parsing comma separated string with prefix

3 Answers 3

7 Comments

Comments

Demo

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

7 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related