Regex to validate CSV in JAVA

Question

Hi I am trying to validate a CSV sheet line by line . The csv file contains :-

9,EditTest,expectedResult=nooptionsacltrue
10,AddTest,features={w;f;r}
1,AddTest,projectType=new,vtName=28HPM,status=ACTIVE,canOrder=Yes,expectedResult=duplicate
2,AddTest,projectType=old,vtName=28nm,status=ACTIVE,canOrder=Yes,expectedResult=invalidfeatures

Here is my code :-

    public class Example {

    public static void main(String[] args) throws Exception {

            BufferedReader br = new BufferedReader(new FileReader("testdbcsv/ACL.csv"));
            while((line=br.readLine())!=null){
                String pattern = "^(\\d+),(\\w+),((\\w+)=(\\w+)),((\\w+)=(\\w+)+?";
                if(line.matches(pattern)){
                    System.out.println("pattern matched");
                }
//Code
}

But my regex seems incorrect . Can anyone please help me with the correct regex for the csv. Thanks . Or is there any other way where I can validate my CSV according to a schema other than using regular expressions?

Yes but is there a way to convert the csv to a xml and validate?> — Newbie
– Newbie, Commented Nov 21, 2013 at 7:54

Adarsh · Accepted Answer · 2013-11-21 08:03:43Z

2

Assuming that the validation for the second line should fail,

^(\\d),[A-Za-z]+(,[A-Za-z]+=[A-Za-z0-9]+)+$

EDIT

This should match all four lines in your given csv.

^(\\d)+,[A-Za-z]+(,[A-Za-z]+=[A-Za-z0-9{};]+)+$

edited Nov 21, 2013 at 8:03

answered Nov 21, 2013 at 7:50

Adarsh

3,6592 gold badges23 silver badges38 bronze badges

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

Comments

OneSix · Accepted Answer · 2013-11-21 07:31:05Z

1

CsvValidator, A Java framework which validates any CSV files can used.

Check this url : http://mdshannan1.blogspot.in/2011/07/validating-csv-files.html

answered Nov 21, 2013 at 7:31

OneSix

713 bronze badges

Comments

AJ. · Accepted Answer · 2013-11-21 09:31:14Z

1

try this one "\\d+,\\w+(,\\w+=\\w+)+"

edited Nov 21, 2013 at 9:31

answered Nov 21, 2013 at 7:01

AJ.

4,5355 gold badges32 silver badges43 bronze badges

Collectives™ on Stack Overflow

Regex to validate CSV in JAVA

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related