Multiple occurrences of each capturing group in Javascript regex

Question

I'm trying to get the tables and aliases of a SQL select statement, for example the following select:

select * from table1 t1, table2, table3 t3, table4 where column = 1

should return two capturing groups, the first one table1, table2, table3 and table4. The second capturing group t1, null, t3 and null.

My attempt returns only the first item of each capturing group:

from\s+([^ ,]+)\s*(\w+)*,

returns table1 and t1 only. How to expand the regex to retrieve all the occurrences?

I don't see how the question you're proposing as dup answers my question — ps0604, May 13 '15 at 03:20
@pgschr: The solution you get is also match, then split by delimiter. So it's more or less a duplicate. — nhahtdh, May 13 '15 at 05:20

Downgoat · Accepted Answer · 2015-05-13T03:25:44.147

1

Assuming str is your string

var tables = str.match(/from\s(.*)\swhere/)[1].split(/, /);

Returns:

["table1 t1", "table2", "table3 t3", "table4"]

edited May 13 '15 at 03:25

answered May 13 '15 at 02:22

Downgoat

I need to relate the alias to the table name, for example table3 with t3, in your Regex I cannot do that – ps0604 May 13 '15 at 02:58
@pgschr ah, that's even easier. I'll update my answer – Downgoat May 13 '15 at 03:24

1 Answers1