Java split string with RegexOption.MULTILINE

Question

I want to split for example the following Sql statements by semi-colon end of line:

CREATE TABLE projects(
   id INTEGER PRIMARY KEY AUTOINCREMENT     NOT NULL,
   name           TEXT    NOT NULL,
   created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
);

CREATE INDEX ix_tasks_project_id ON tasks (project_id);

SELECT * FROM projects WHERE name = "someName;WithSemiColon";

Something like: string.split(";$"); (but with RegexOption.MULTILINE applied)

Can someone please explain how do I apply the RegexOption?

if its posted like this you can simply split at ; with no need of regex or anything else — XtremeBaumer
– XtremeBaumer, Commented Jan 17, 2017 at 12:18
Thanks. This is just an example. I want to cater for when ; appears within sql statements as well. I'm looking to split sql statements using a reliable regex. — abstractx1
– abstractx1, Commented Jan 17, 2017 at 12:20

Nicolas Filotto · Accepted Answer · 2017-01-17 12:32:45Z

5

Simply prefix your regular expression with (?m) to enable the flag MULTILINE so in your case it would be (?m);$

for (String s : string.split("(?m);$")) {
    System.out.printf("----> %s%n", s.trim());
}

Output:

----> CREATE TABLE projects(
   id INTEGER PRIMARY KEY AUTOINCREMENT     NOT NULL,
   name           TEXT    NOT NULL,
   created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
)
----> CREATE INDEX ix_tasks_project_id ON tasks (project_id)
----> SELECT * FROM projects WHERE name = "someName;WithSemiColon"

edited Jan 17, 2017 at 12:32

answered Jan 17, 2017 at 12:20

Nicolas Filotto

45.2k11 gold badges97 silver badges129 bronze badges

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

2 Comments

abstractx1 Over a year ago

Thank you but this does not seem to split the string.

abstractx1 Over a year ago

I apologize. You're right. After looking further into the parser, the newlines were being removed. Thank you so much for your help.

Collectives™ on Stack Overflow

Java split string with RegexOption.MULTILINE

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related