Linking the EFS id to the DATA ID

HI Forum

I am wondering if anyone can help me with the following issue i have encountered.

I am trying to link files extracted via OE back to their system DataID's, i have Exporter references in the format 0000000418 , but i am wondering if there is any way i can tie these back to the actual files on the system, how would i locate them ?

Any suggestions or help would be greatly appreciated

Regards

Mike.

Find more posts tagged with

Comments

Bhupinder_Singh

Let me know if this article is of help:

https://knowledge.opentext.com/knowledge/cs.dll/open/3500536

-Bhupinder
----------------------------------------------
Bhupinder Singh, B.Math, B.Ed.
Systems Administrator, Cloud Services
Open Text, Waterloo, Ontario, Canada
----------------------------------------------

Colin_Schmidt

If you want to strip out the path of the docment to a more usable string, you can add the following code in the Select, if in Oracle:

REGEXP_REPLACE(REGEXP_SUBSTR(pd.providerdata, '([[:digit:]]{3,}..[[:digit:]]{3,}..[[:digit:]]{6,}.dat)', REGEXP_INSTR(pd.providerdata, '=', 1, 1, 1), 1), '\\\\', '\\') "ProviderPath"

There may be better or cleaner SQL for this.