M regex to check if all the digits of phone are same is "^([0-9])\\1*$". But it is not working with regexp_like in semarchy. this regex is working in java plugin. my data location is sql server. i tried to check this regex in sql server using like operator. It is not working in sql server. currently i have used java plugin in my project.
Is there any possible way to use regex in semarchy where data location is sql server?
Best Answer
C
Cédric BLANC
said
about 2 years ago
Regexp is not natively supported by SQL Server, therefore you won't be able to use regex functions if the Datasource for your Data Location is SQL Server.
Furthermore, in SQL Server REGEXP_LIKE is equivalent to the LIKE operator.
1 Comment
Cédric BLANC
said
about 2 years ago
Answer
Regexp is not natively supported by SQL Server, therefore you won't be able to use regex functions if the Datasource for your Data Location is SQL Server.
Furthermore, in SQL Server REGEXP_LIKE is equivalent to the LIKE operator.
Cédric BLANC
M regex to check if all the digits of phone are same is "^([0-9])\\1*$". But it is not working with regexp_like in semarchy. this regex is working in java plugin. my data location is sql server. i tried to check this regex in sql server using like operator. It is not working in sql server. currently i have used java plugin in my project.
Is there any possible way to use regex in semarchy where data location is sql server?
Regexp is not natively supported by SQL Server, therefore you won't be able to use regex functions if the Datasource for your Data Location is SQL Server.
Furthermore, in SQL Server REGEXP_LIKE is equivalent to the LIKE operator.
Cédric BLANC
Regexp is not natively supported by SQL Server, therefore you won't be able to use regex functions if the Datasource for your Data Location is SQL Server.
Furthermore, in SQL Server REGEXP_LIKE is equivalent to the LIKE operator.
-
Extend a model with new entities or attributes
-
Data types in xDM
-
Effective date on entities
-
Search using wild cards
-
Export a model from production and import on a development environment
-
"Allow Delete" vs "Allow Removal" privileges
-
LOV label in Named Query
-
Select location on a map and save coordinates
-
Is there a way to set up a master-detail relationship on browse mode?
-
Choose Either a Stepper or A Workflow Based on The User Privileges
See all 269 topics