Displaying 1 result from an estimated 1 matches for "xxx_xxx".
Did you mean:
xx_xxxx
2012 Aug 24
1
Regular expressions: stuck again...
...uot; FROM \"public\".\"tblFiche\",
\"public\".\"tblArtnr\" WHERE \"public\".\"tblFiche\".\"Artnr_ID\" =
\"public\".\"tblArtnr\".\"Artnr_ID\";
concrete:
The square backets [ and ] should removed
and xxx_xxx.xxx should become \"xxx\".\"xxx\"\".\"xxx\"
When only queries with square brackets, I used
gsub('[', '\"', x, fixed=TRUE),
gsub(']', '\"', x, fixed=TRUE),
gsub('_', '\"', x, fixed=TRUE),
But to...