Regex for SOQL Query String

Question

I have the below SOQL query:

SELECT Description,(Select Name,Id from Contacts) , Account.Name, (Select Id from Contacts) from Account

I want to apply regex in java to extract following -

SELECT Description, Account.Name from Account

Not sure I understand - you want to extract a constant string from the SQL query itself? Or is this just an example of a regex you want to apply across many queries? — DNA
– DNA, Commented Oct 5, 2012 at 6:48

Chathuranga Chandrasekara · Accepted Answer · 2012-10-05 08:26:53Z

1

Quick solution custom tailored to the expression given:

String query = "SELECT Description,(Select Name,Id from Contacts) , Account.Name, (Select Id from Contacts) from Account";

// Remove all subqueries (things in parenthesis)
// Remove doubled commas (even with space in between)
// Remove a comma before the from
String answer = query
    .replaceAll("\\(.*?\\)", "")
    .replaceAll(",\\s*,", ",")
    .replaceAll(",\\s*from", " from");

edited Oct 5, 2012 at 8:26

Chathuranga Chandrasekara

21.1k31 gold badges101 silver badges138 bronze badges

answered Oct 5, 2012 at 6:55

Cory Kendall

7,3349 gold badges40 silver badges66 bronze badges

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

Collectives™ on Stack Overflow

Regex for SOQL Query String

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related