Regular Expression in Javascript for finding parameters

Question

I'm trying to write a regular expression in javascript to catch all named parameters in PostgreSQL string to put them in table

lets say we have

var query="SELECT table.data FROM table JOIN table2 ON table2.id=table.id_tab2 WHERE table2.field <> :parm1::int GROUP BY table.data HAVING table.data position(:docType::text in document_type) <> 0

var tab=new Array();

//

I need rs to put into tab all parameters: "param1::int" and "docType::text" I tried do it myself but with no success :( http://regexr.com?31nok

just somebody · Accepted Answer · 2012-08-03 12:13:37Z

1

something like this? :(\w+::\w+)

answered Aug 3, 2012 at 12:13

just somebody

19.4k6 gold badges55 silver badges65 bronze badges

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

3 Comments

Qsario Over a year ago

I saw - and _ in that character class, which \w won't match. Are those characters allowed in postgres named parameters?

just somebody Over a year ago

@Qsario: in what character class? BTW, dash (-) is not allowed in postgresql typenames as far as i know, and underscore is matched by \w. i don't see a problem here.

Qsario Over a year ago

I was looking at his original character class in regexr. And it appeared that \w wasn't matching _ there, but I might just have been tired.

Nhu Trinh · Accepted Answer · 2012-08-03 12:15:10Z

1

and (:[a-zA-Z0-9]+::[a-zA-Z0-9]+)

answered Aug 3, 2012 at 12:15

Nhu Trinh

14k6 gold badges66 silver badges88 bronze badges

1 Comment

T.G Over a year ago

it amost what i wonted. Difference is, thay i need those parameters without : on begin tried with :([a-z0-9_-]+::[a-z0-9_-]+) ,but effect is the same

Qsario · Accepted Answer · 2012-08-03 12:15:23Z

1

There can be weird things between a-Z, so just use [a-z] with case insensitive or [a-zA-Z]. I think you probably want a global match (find all results). Multi-line is something else, it makes . match \n which doesn't help you that I can see. Try this: http://regexr.com?31not

answered Aug 3, 2012 at 12:15

Qsario

1,0261 gold badge9 silver badges18 bronze badges

Comments

T.G · Accepted Answer · 2012-08-09 07:32:45Z

0

when i try :([^: ]+::[^: ]+) and (:[^: ]+::[^: ]+) i see no difference- colon is in match in both casec.

However i found some other way

(?!:)([a-z0-9_-]+::[a-z0-9_-]+)

works perfectly. first part (?<=:) determine "Matches a group before your main expression without including it in the result."

Thanks you all for your answers ;)

edited Aug 9, 2012 at 7:32

answered Aug 3, 2012 at 13:00

T.G

1,9311 gold badge16 silver badges30 bronze badges

Collectives™ on Stack Overflow

Regular Expression in Javascript for finding parameters

4 Answers 4

3 Comments

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

3 Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related