You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

regexp_replace not working in etext template

Accepted answer
113
Views
2
Comments

Summary:

regexp_replace not working in etext template

Content (required):

We have a requirement to remove extra semicolon from the string. Using regexp_replace, we are able to acheive it but it is working in etext template.

Ex: 'test;test1;test2;;;;;;test3;;' -> 'test;test1;test2;test3'

Can anyone suggest why regexp is not working in etext template. do we have any alternative solution to this ?

Version (include the version you are using, if applicable):

23A

Code Snippet (add any code snippets that support your topic, if applicable):

regexp_replace( 'test;test1;test2;;;;;;test3;;' ,'([;\|])+\1','\1') - Working and o.p is 'test;test1;test2;test3'

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!