Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
THRUST SERVICES & TOOLS
CLOUD EDITIONS
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Content Management (Extended ECM)
API, SDK, REST and Web Services
How to get document string only from providerdata table
OPB_Admin
providerdata table give the results like A<1,?,'providerInfo'='ixos://Docman@aag4zh1vkhsez45pmubuedned1cmm','storageProviderName'='EnterpriseArchive','subProviderName'='Docman'>how can I get only 'aag4zh1vkhsez45pmubuedned1cmm' from that string?
Find more posts tagged with
Comments
Craig_Stanley
We had a similar requirement to strip out comments from PulseWe used Oracle Regular Expressions which you could adaptselect replace(substr(regexp_substr(DSOCIALFEEDEVENTS.eventinfo,'''text''=''[^'']{1,}'''),8),'''',''), dtree.namefrom dtree, DSOCIALFEEDEVENTS where DSOCIALFEEDEVENTS.dataid= dtree.dataid
