java - SOQL 查询字符串的正则表达式

Question

我有以下 SOQL 查询:

选择描述，(从联系人中选择姓名、ID)，帐户.名称，(从联系人中选择 ID)从帐户

我想在java中应用正则表达式来提取以下内容 -

从帐户中选择描述、帐户名称

Answer 1

根据给定的表达式定制快速解决方案:

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");